Postgres Pro
Downloads
Home   >   mailing lists

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

From Łukasz Jarych
Subject Re: VBA to connect to postgresql from MS Access
Date
Msg-id CAGv31oeEdoqS1==iyQHWp--6mVj170-yj+7MuXy44yXKCPPG5A@mail.gmail.com
Whole thread Raw
In response to Re: VBA to connect to postgresql from MS Access  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Setting up replication from 9.4 to 10.4
Next
From: Lionel Tressens
Date:
Subject: Re: Setting up replication from 9.4 to 10.4