Postgres Pro
Downloads
Home   >   mailing lists

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

From Łukasz Jarych
Subject VBA to connect to postgresql from MS Access
Date
Msg-id CAGv31ocBxGw3YSf8MF-Y=tJu2FLJr_JgSHTtMhBh55V_eXD4uw@mail.gmail.com
Whole thread Raw
Responses Re: VBA to connect to postgresql from MS Access  ("Arnaud L." <arnaud.listes@codata.eu>)
Re: VBA to connect to postgresql from MS Access  (Łukasz Jarych <jaryszek@gmail.com>)
List pgsql-general
Tree view
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  
   

pgsql-general by date:

Previous
From: Fabio Pardi
Date:
Subject: Re: Question on disk contention
Next
From: "Arnaud L."
Date:
Subject: Re: VBA to connect to postgresql from MS Access