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

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.klaver@aklaver.com