Re: VBA to connect to postgresql from MS Access

Поиск
Список
Период
Сортировка
От Łukasz Jarych
Тема Re: VBA to connect to postgresql from MS Access
Дата
Msg-id CAGv31oeEdoqS1==iyQHWp--6mVj170-yj+7MuXy44yXKCPPG5A@mail.gmail.com
обсуждение исходный текст
Ответ на Re: VBA to connect to postgresql from MS Access  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Hi Adrian and Mike,

All is working fine, thank you ! 
Problem was with connection string and 32 bit computer. 

My access is 32 bit so i should have odbc 32 bit driver for postgresql...

Best,
Jacek



2018-06-04 15:31 GMT+02:00 Adrian Klaver <adrian.klaver@aklaver.com>:
On 06/03/2018 09:30 PM, Łukasz Jarych wrote:
Thank you Adrian,

in answer to response in link:

This connection string is not working for me.

How it is not working?

Do you get error messages?

And my conf file is in attachment.

Only this strange DSN less conn string is working:

I am not following the below does use a DSN.

What are the parameters for the DSN PostgreSQL35W?



    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*


Why?

Best,
Jacek



--
Adrian Klaver
adrian.klaver@aklaver.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Andreas Kretschmer
Дата:
Сообщение: Re: Setting up replication from 9.4 to 10.4
Следующее
От: Lionel Tressens
Дата:
Сообщение: Re: Setting up replication from 9.4 to 10.4