Hi Guys,
when i jhave 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:
Code:
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:
Code:
DRIVER={PostgreSQL Unicode(x64)};DATABASE=AccessTest;SERVER=localhost;PORT=5432;UID=postgres;PWD=1234;"
But this code is not working... only this long one.
What i am doing wrong?
Best,
Jacek