Search Postgresql Archives

Re: VBA to connect to postgresql from MS Access

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

 



Le 01-06-18 à 14:21, Łukasz Jarych a écrit :
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*

When i was searching code for this in internet i found only:
    DRIVER={PostgreSQL Unicode(x64)};DATABASE=AccessTest;SERVER=localhost;PORT=5432;UID=postgres;PWD=1234;"

but this is not working, why? I do not know what these CA, BO, BI strange paramaters.
Why is this not working, we cannot answer without the error message you get. You probably use the wrong driver name.

As for the CA, BO, etc... they are abreviations of the keywords. You can use either the keywords or the abreviations in your connection string, and they are all explained here :
https://odbc.postgresql.org/docs/config-opt.html


--
Arnaud




[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