From: | "Arnaud L(dot)" <arnaud(dot)listes(at)codata(dot)eu> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: VBA to connect to postgresql from MS Access |
Date: | 2018-06-01 12:27:03 |
Message-ID: | 40449b8f-b25c-ce8d-1484-148c67ff8afc@codata.eu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Steven Lembark | 2018-06-01 13:35:44 | Re: reduce number of multiple values to be inserted |
Previous Message | Łukasz Jarych | 2018-06-01 12:21:38 | VBA to connect to postgresql from MS Access |