Re: Fwd: problem with using VBA connection string to postgresql

2018-06-27 Thread Łukasz Jarych
Hi Adrian, John Pedro answered me, problem was that i had ODBC in the beginning of connection string... Strange, but in table connector you have to have ODBC in connection string, in directly connetion you can not have... Best 2018-06-27 14:49 GMT+02:00 Adrian Klaver : > On 06/27/2018 05:27 AM

Re: Fwd: problem with using VBA connection string to postgresql

2018-06-27 Thread Adrian Klaver
On 06/27/2018 05:27 AM, Łukasz Jarych wrote: Maybe some security here? 32/64 bit mismatch? Do you have both the 32 and 64 bit versions of the ODBC driver installed? Is your application calling the correct version? Best, Jacek Hi Guys, I am using code : Sub copyingSchemas() Dim

Fwd: problem with using VBA connection string to postgresql

2018-06-27 Thread Łukasz Jarych
Maybe some security here? Best, Jacek Hi Guys, I am using code : Sub copyingSchemas() > Dim dbCon As Object > Dim rst As Object > Dim username, pass, strConnect As String > username = Environ("username") > pass = "PasswordAccess" > Set dbCon = CreateObject("ADODB.Connection") > Set rst = Creat

problem with using VBA connection string to postgresql

2018-06-27 Thread Łukasz Jarych
Hi Guys, I am using code : Sub copyingSchemas() > Dim dbCon As Object > Dim rst As Object > Dim username, pass, strConnect As String > username = Environ("username") > pass = "PasswordAccess" > Set dbCon = CreateObject("ADODB.Connection") > Set rst = CreateObject("ADODB.Recordset") > '''You can u