Re: VBA to connect to postgresql from MS Access - Mailing list pgsql-general

From Arnaud L.
Subject Re: VBA to connect to postgresql from MS Access
Date
Msg-id 40449b8f-b25c-ce8d-1484-148c67ff8afc@codata.eu
Whole thread Raw
In response to VBA to connect to postgresql from MS Access  (Łukasz Jarych <jaryszek@gmail.com>)
Responses Re: VBA to connect to postgresql from MS Access  (Bret Stern <bret_stern@machinemanagement.com>)
List 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 by date:

Previous
From: Łukasz Jarych
Date:
Subject: VBA to connect to postgresql from MS Access
Next
From: Steven Lembark
Date:
Subject: Re: reduce number of multiple values to be inserted