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 по дате отправления:

Предыдущее
От: Łukasz Jarych
Дата:
Сообщение: VBA to connect to postgresql from MS Access
Следующее
От: Steven Lembark
Дата:
Сообщение: Re: reduce number of multiple values to be inserted