Re: VBA to connect to postgresql from MS Access

On 06/02/2018 11:15 AM, Łukasz Jarych wrote:
> Anyone?

https://www.postgresql.org/message-id/1527872841.3939.24.camel%40bret.machinemanagement.com

> 
> Jacek
> 
> 2018-06-01 14:21 GMT+02:00 Łukasz Jarych <jaryszek@gmail.com 
> <mailto:jaryszek@gmail.com>>:
> 
>     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
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com