Results 1 to 3 of 3
  1. #1
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568

    Strange connection string to postgresql VBA

    Hi Guys,



    when i jhave 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:

    Code:
    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:

    Code:
    DRIVER={PostgreSQL Unicode(x64)};DATABASE=AccessTest;SERVER=localhost;PORT=5432;UID=postgres;PWD=1234;"
    But this code is not working... only this long one.

    What i am doing wrong?

    Best,
    Jacek

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716

  3. #3
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    Thank you orange,

    but i know how to connect using DSN. How to connect using DSN less connection - this is a question.

    Best,
    Jacek

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 03-23-2018, 07:54 AM
  2. Connection String to Postgre
    By martingaleh in forum Programming
    Replies: 3
    Last Post: 04-13-2016, 05:28 PM
  3. Remote Desktop Connection Broker connection string
    By Philosophaie in forum Access
    Replies: 1
    Last Post: 09-14-2015, 03:51 PM
  4. Connection string error
    By Philosophaie in forum Access
    Replies: 3
    Last Post: 09-08-2015, 10:26 PM
  5. Connection String
    By cradaa in forum Access
    Replies: 4
    Last Post: 05-24-2011, 07:28 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums