From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Łukasz Jarych <jaryszek(at)gmail(dot)com>, "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Fwd: problem with using VBA connection string to postgresql |
Date: | 2018-06-27 12:49:29 |
Message-ID: | 7296288d-52c1-6f6c-189b-71fb630b0661@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 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 use a pass-through query to list the table names from
> your SQL Server database. Open a recordset based on that query. Then
> loop through the recordset rows and link each table.
> username = "postgres"
> pass = "1234"
> strConnect = "ODBC;DRIVER={PostgreSQL Unicode};" & _
> "DATABASE=AccessLog;" & _
> "SERVER=localhost;" & _
> "PORT=5432;" & _
> "UID=" & username & ";" & _
> "PWD=" & pass & ";" & _
> "Trusted_Connection=Yes;"
> dbCon.ConnectionString = strConnect
> dbCon.Open
> Dim strSQl As String
> strSQl = "SELECT * FROM t_cpuinfo();"
> rst.Open strSQl
> dbCon.Close
>
> End Sub
>
>
> error is :
>
>
>
>
> Linked Table connection string which is working :
>
>
>
> Why?
>
> Please help,
> Best,
> Jacek
>
>
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Łukasz Jarych | 2018-06-27 12:51:09 | Re: Fwd: problem with using VBA connection string to postgresql |
Previous Message | Łukasz Jarych | 2018-06-27 12:27:02 | Fwd: problem with using VBA connection string to postgresql |