From: | Łukasz Jarych <jaryszek(at)gmail(dot)com> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
Subject: | VBA to connect to postgresql from MS Access |
Date: | 2018-06-01 12:21:38 |
Message-ID: | CAGv31ocBxGw3YSf8MF-Y=tJu2FLJr_JgSHTtMhBh55V_eXD4uw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Guys,
When i have linked table based on DSN odbc connection to postgresql ,
i am going to :
VBA editor, in immediate window inputing:
?CurrentDb.TableDefs("TableName").Connect
i have very strange connection string:
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.
I want to use VBA to relink all tables and use DSN less connection string.
Please help,
Best,
Jacek
>
From | Date | Subject | |
---|---|---|---|
Next Message | Arnaud L. | 2018-06-01 12:27:03 | Re: VBA to connect to postgresql from MS Access |
Previous Message | Fabio Pardi | 2018-06-01 11:45:19 | Re: Question on disk contention |