Connection options

Devart ODBC Driver for PostgreSQL provides a direct TCP/IP connection to a PostgreSQL server and doesn’t require PostgreSQL client libraries.

To establish a direct connection, specify the parameters in the driver configuration dialog:

  • Server – The host name or IP address of the PostgreSQL server.
  • Port – The port number for the connection. The default port is 5432.
  • User ID – The PostgreSQL username.
  • Password – The PostgreSQL password.
  • Database (optional) – The default database to connect to.
  • Schema (optional) – The default schema to use.

The Devart ODBC Driver for PostgreSQL Configuration window with completed fields

Sample connection string:

DRIVER={Devart ODBC Driver for PostgreSQL};User ID=myUsername;Password=myPassword;Server=myServer;Database=myDatabase;Schema=mySchema;