Re: VBA to connect to postgresql from MS Access

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: Łukasz Jarych <jaryszek(at)gmail(dot)com>
Cc: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: VBA to connect to postgresql from MS Access
Date: 2018-06-04 13:31:32
Message-ID: dfe07672-2d52-a53e-1c6b-d9088eadb89f@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Benjamin Scherrey 2018-06-04 13:33:12 Re: Code of Conduct plan
Previous Message Melvin Davidson 2018-06-04 13:23:29 Re: How to get postmaster shut down time in postgres?