Re: VBA to connect to postgresql from MS Access
| От | Arnaud L. |
|---|---|
| Тема | Re: VBA to connect to postgresql from MS Access |
| Дата | |
| Msg-id | 40449b8f-b25c-ce8d-1484-148c67ff8afc@codata.eu обсуждение |
| Ответ на | VBA to connect to postgresql from MS Access (Łukasz Jarych <jaryszek@gmail.com>) |
| Ответы |
Re: VBA to connect to postgresql from MS Access
|
| Список | pgsql-general |
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
В списке pgsql-general по дате отправления: