• dotConnect for PostgreSQL (former Core Labs PostgreSQLDirect)

    • Standard

      User ID=root;Password=myPassword;Host=localhost;Port=5432;Database=myDataBase;
      Pooling
      =true;Min Pool Size=0;Max Pool Size=100;Connection Lifetime=0;
      PostgreSQL

    Problems connecting?   Get answer in the PostgreSQL Q & A forum →

  • PostgreSQL OLE DB Provider

    • Standard

      PgOleDb requires a PQLib of version 7.4 or up and it also requires a backend of version 7.4 or up. Timestamps are only guarenteed to work with backends of version 8.0 and up.

      Provider=PostgreSQL OLE DB Provider;Data Source=myServerAddress;
      location
      =myDataBase;User ID=myUsername;password=myPassword;timeout=1000;

      Other valid Provider values is "PostgreSQL" and "PostgreSQL.1"

      PostgreSQL
    • Standard alternative

      Some reported problems with the above one. Try removing the timeout parameter to make it work.

      Provider=PostgreSQL OLE DB Provider;Data Source=myServerAddress;
      location
      =myDataBase;User ID=myUsername;password=myPassword;
      PostgreSQL
  • .NET Framework Data Provider for OLE DB

    • Use an OLE DB provider from .NET

      Provider=any oledb provider's name;OledbKey1=someValue;OledbKey2=someValue;

      See the respective OLEDB provider's connection strings options. The .net OleDbConnection will just pass on the connection string to the specified OLEDB provider. Read more here.

  • PostgreSQL ODBC Driver (psqlODBC)

    • Standard

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

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

      Driver={PostgreSQL UNICODE};Server=IP address;Port=5432;Database=myDataBase;
      Uid
      =myUsername;Pwd=myPassword;
      PostgreSQL
    • 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.

      PostgreSQL
  • Npgsql

    • Standard

      Server=127.0.0.1;Port=5432;Database=myDataBase;User Id=myUsername;
      Password
      =myPassword;
      PostgreSQL
    • Using windows security

      Server=127.0.0.1;Port=5432;Database=myDataBase;Integrated Security=true;
      PostgreSQL
    • Setting command timeout

      Server=127.0.0.1;Port=5432;Database=myDataBase;User Id=myUsername;
      Password
      =myPassword;CommandTimeout=20;

      The CommandTimeout parameter is measured in seconds and controls for how long to wait for a command to finish before throwing an error.

      PostgreSQL
    • Setting connection timeout

      Server=127.0.0.1;Port=5432;Database=myDataBase;User Id=myUsername;
      Password
      =myPassword;Timeout=15;

      The Timeout parameter is measured in seconds and controls for how long to wait for a connection to open before throwing an error.

      PostgreSQL
    • Specifying protocol version

      Server=127.0.0.1;Port=5432;Database=myDataBase;User Id=myUsername;
      Password
      =myPassword;Protocol=3;

      Valid values for the key Protocol is 2 or 3.

      PostgreSQL
    • SSL activated

      Server=127.0.0.1;Port=5432;Database=myDataBase;Userid=myUsername;
      Password
      =myPassword;Protocol=3;SSL=true;SslMode=Require;
      PostgreSQL
    • Without SSL

      Server=127.0.0.1;Port=5432;Database=myDataBase;Userid=myUsername;
      Password
      =myPassword;Protocol=3;SSL=false;SslMode=Disable;
      PostgreSQL
    • Controlling pooling mechanisms

      Server=127.0.0.1;Port=5432;Database=myDataBase;Userid=myUsername;
      Password
      =myPassword;Protocol=3;Pooling=true;MinPoolSize=1;MaxPoolSize=20;
      ConnectionLifeTime
      =15;
      PostgreSQL
  • .NET Framework Data Provider for ODBC

    • Use an ODBC driver from .NET

      Driver={any odbc driver's name};OdbcKey1=someValue;OdbcKey2=someValue;

      See the respective ODBC driver's connection strings options. The .net OdbcConnection will just pass on the connection string to the specified ODBC driver. Read more here.

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.