Loading ad...

Connection strings for Postgre SQL

dotConnect for PostgreSQL (former Core Labs PostgreSQLDirect)

Type .NET Framework Class Library
 Usage Devart.Data.PostgreSql.PgSqlConnection
 Manufacturer Devart
More info and class library downloads

Set example values

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;
 
 

Npgsql

Type .NET Framework Class Library
 Usage Npgsql.NpgsqlConnection
 Manufacturer Npgsql Development Team
More info and class library downloads

Set example values

Standard

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

Using windows security

    
Server=127.0.0.1;Port=5432;Database=myDataBase;Integrated Security=true;
 
 

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.

 
 

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.

 
 

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.

 
 

SSL activated

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

Without SSL

    
Server=127.0.0.1;Port=5432;Database=myDataBase;Userid=myUsername;Password=myPassword;
Protocol=3;SSL=false;SslMode=Disable;
 
 

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 OLE DB Provider

Type OLE DB Provider
 Usage Provider=PostgreSQL OLE DB Provider
 Manufacturer PgOleDb Development Team
More info and provider downloads

Set example values

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"

 
 

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;

 
 

.NET Framework Data Provider for OLE DB

Type .NET Framework Wrapper Class Library
 Usage System.Data.OleDb.OleDbConnection
 Manufacturer Microsoft
More info and wrapper class library downloads

Set example values

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)

Type ODBC Driver
 Usage Driver={PostgreSQL}
 Manufacturer PostgreSQL
More info and driver downloads

Set example values

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.

 
 

.NET Framework Data Provider for ODBC

Type .NET Framework Wrapper Class Library
 Usage System.Data.Odbc.OdbcConnection
 Manufacturer Microsoft
More info and wrapper class library downloads

Set example values

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.

 
 

Popular