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 : > On 06/03/2018 09:30 PM, Łukasz Jarych wrote: > >> Th

Re: VBA to connect to postgresql from MS Access

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 fo

RE: VBA to connect to postgresql from MS Access

From: Łukasz Jarych [mailto:jarys...@gmail.com] Sent: Monday, June 04, 2018 12:30 AM To: Adrian Klaver Cc: pgsql-gene...@postgresql.org >> PG-General Mailing List Subject: Re: VBA to connect to postgresql from MS Access Thank you Adrian, in answer to response in link: This conn

Re: VBA to connect to postgresql from MS Access

Thank you Adrian, in answer to response in link: This connection string is not working for me. Ma macro is: Public Sub InitConnect() > > >> On Error GoTo ErrHandler > > >> Dim dbCurrent As DAO.Database > > Dim qdf As DAO.QueryDef > > Dim rst As DAO.Recordset > > Dim cnn As Objec

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 >: Hi Guys, When i have linked table based on DSN odbc connec

Re: VBA to connect to postgresql from MS Access

Anyone? Jacek 2018-06-01 14:21 GMT+02:00 Łukasz Jarych : > 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: > >

Re: VBA to connect to postgresql from MS Access

Not sure what version of access you're using or how you are calling the connection..ADO, DAO, .NET I don't hard code connection strings anymore, but I did when I first started. Nowadays I call a registry function to put the drivers on a specific pc into a listbox and have a setup module which then

Re: VBA to connect to postgresql from MS Access

Le 01-06-18 à 14:21, Łukasz Jarych a écrit : 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;SERV

VBA to connect to postgresql from MS Access

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;