PostgreSQL ODBC Driver (psqlODBC)


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;