hi groups, update : now iam already connect to postgresql, what iam doing is just installing postgre driver and set the path environtment variable and now xpa could connect to postgresql db. now i wan

#xpa #postgresql

hi roberto, may i know are your problem already solved about load postgresql? i have same experience with you, i have license xpa 4.6 and the license contains "POSTGREGW=Y", iam using postgresql v13.

#xpa #postgresql

Hello Yuval, In my journey looking to make the PostgreSQL Gateway work I discovered several things: 1. There is a mystery writer working at MSE. There are the only three lines in the Release Notes for

#xpa #postgresql

Roberto, Having no experience with PostgreSQL all I can suggest is to create an ODBC data source using the psqlODBC driver. Reopen the toolkit and see if the PostgreSQL gateway is loaded. If this does

#xpa #postgresql

Thank you all, I am getting closer to the solution. I added the folder "C:\Program Files (x86)\psqlODBC\1101\bin" to the PATH environment variable in my computer and the "load driver error.." is gone.

#xpa #postgresql

Hi , As I understand, Magic 4.x development is still 32-bit exe, while deployment is either 32-bit or 64-bit , but 64-bit one is only for server use ( ie. background engines , not online ) Below is a

#xpa #postgresql

Thats a good question because obviously, you do work with the new Xpa 64-Bit version and that _should_ work just fine with a 64-Bit PostgresSQL ODBC driver. Now I do ofc not know Xpa 4.6 and cant tell

#xpa #postgresql

Hi Roberto, As an example , MySql gateway is built on top of 32-bit MySql ODBC driver. I guess Postgres is the same, though I don't have a way to check it. BR Przemek

#xpa #postgresql

I had the same experience recently with Oracle Personal Edition. I had to download and install a separate 32 bit client. Once I did this the gateway error went away. Todd On 1/17/2020 2:41 PM, Steven

#xpa #postgresql

No, just install the one(s) you actually want to use. If you already have the gateway, then my job is done, here. In this case, I suspect that you also need to install a PostgreSQL client which very w

#xpa #postgresql

Hello, Why would I need a 32-bit ODBC driver to connect to PostgreSQL if Magic has a brand new native Gateway for it? Roberto

#xpa #postgresql

Steve, I do install all the Gateways during the installation of XPA and later comment out the ones I do not use. I do have the postgresql gateway installed. Roberto

#xpa #postgresql

Hi Roberto, Since Magic is 32-bit I guess you need some 32-bit Postgres client, possibly 32-bit ODBC driver . At least for development ! HTH Przemek

#xpa #postgresql

In prior versions, a "Typical" installation of the Studio would not install all of the gateways – one had to explicitly select the gateways that one wanted to be installed. Perhaps you did not explici

#xpa #postgresql

Hello, I get the error message telling me "Failed to load driver: c:\magic\xpa\46\gateways\mgpostgreSQL.dll" in Magic XPA 4.6 I downloaded the installation program for postgreSQL11.6 from their web si

#xpa #postgresql