PostgreSQL ODBC Driver (psqlODBC) connection strings

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.