Re: VBA to connect to postgresql from MS Access

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(dot)klaver(at)aklaver(dot)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(dot)klaver(at)aklaver(dot)com
>