Search Postgresql Archives

Re: VBA to connect to postgresql from MS Access

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi Adrian and Mike,

All is working fine, thank you ! 
Problem was with connection string and 32 bit computer. 

My access is 32 bit so i should have odbc 32 bit driver for postgresql...

Best,
Jacek



2018-06-04 15:31 GMT+02:00 Adrian Klaver <adrian.klaver@xxxxxxxxxxx>:
On 06/03/2018 09:30 PM, Łukasz Jarych wrote:
Thank you Adrian,

in answer to response in link:

This connection string is not working for me.

How it is not working?

Do you get error messages?

And my conf file is in attachment.

Only this strange DSN less conn string is working:

I am not following the below does use a DSN.

What are the parameters for the DSN PostgreSQL35W?



    ODBC;DSN=PostgreSQL35W;DATABASE=AccessTest;SERVER=localhost;PORT=5432;*CA=d;A7=100;B0=255;B1=8190;BI=0;C2=;CX=1c305008b;A1=7.4*


Why?

Best,
Jacek



--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux