PostgreSQL ODBC Driver (psqlODBC) connection strings

Connects to

PostgreSQL

  • Standard

    Driver={PostgreSQL};Server=IP address;Port=5432;Database=myDataBase;
    Uid
    =myUsername;Pwd=myPassword;
  • ANSI

    Driver={PostgreSQL ANSI};Server=IP address;Port=5432;Database=myDataBase;
    Uid
    =myUsername;Pwd=myPassword;
  • Unicode

    Driver={PostgreSQL UNICODE};Server=IP address;Port=5432;Database=myDataBase;
    Uid
    =myUsername;Pwd=myPassword;
  • SSL

    Secure sockets layer for this driver only works from version 8.0 and above.

    Driver={PostgreSQL ANSI};Server=IP address;Port=5432;Database=myDataBase;
    Uid
    =myUsername;Pwd=myPassword;sslmode=require;

    Please note that sslmode=require is case sensitive, it should be written in lower case letters.

Problems connecting?
Get answer in the PostgreSQL Q & A forum
ODBC DriverDriver={PostgreSQL}Info and driver downloads

Providers

Connect

Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.