Postgres SQL Connection strings - Connectionstring Examples

Connection strings Examples for Progress

Core Labs PostgreSQLDirect (.NET)

This is a .NET Class Library from Devart.

Standard Security:

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

.NET Framework Data Provider for OLE DB

This is a .NET Class Library from Microsoft. The namespace for this library is System.Data.OleDb.OleDbConnection

Standard Security:

Provider=PostgreSQL OLE DB Provider;Data Source=yourServerAddress;location=yourDataBase;User ID=yourUsername;password=yourPassword;timeout=1000;

You can view more OLE DB connection strings for other data provider from other pages.

Npgsql

This is a .NET Class Library from pgFoundry. The namespace for this library is Npgsql.NpgsqlConnection

SSL activated:

Server=127.0.0.1;Port=5432;Database=yourDataBase;Userid=yourUsername;Password=yourPassword; Protocol=3;SSL=true;Pooling=true;MinPoolSize=3;MaxPoolSize=20;Encoding=UNICODE; Timeout=20;SslMode=Require;

Without SSL:

Server=127.0.0.1;Port=5432;Database=yourDataBase;Userid=yourUsername;Password=yourPassword; Protocol=3;SSL=false;Pooling=true;MinPoolSize=1;MaxPoolSize=20;Encoding=UNICODE; Timeout=15;SslMode=Disable;

More Information at pgFoundation website

PostgreSQL ODBC Driver (psqlODBC)

This is an ODBC driver from PostgreSQL. The usage for this driver is Driver={PostgreSQL}

Standard Security:

Driver={PostgreSQL};Server=IP address;Port=5432;Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;

You can view more OLE DB connection strings for other data provider from other pages.

ANSI:

Driver={PostgreSQL ANSI};Server=IP address;Port=5432;Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;

Unicode:

Driver={PostgreSQL UNICODE};Server=IP address;Port=5432;Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;

SSL:

Driver={PostgreSQL ANSI};Server=IP address;Port=5432;Database=yourDataBase;Uid=yourUsername;Pwd=yourPassword;sslmode=require;

Note: sslmode=require is case sensitive, make sure they are all in lower case letters, otherwise you may gets an error.

PostgreSQL OLE DB Provider

This is a OLE DB Provider from pgFoundry. The usage for this library is Provider=PostgreSQL OLE DB Provider.

Make sure you are using PQLib of version 7.4 or later version for this connection string, the back end also requires 7.4 or later version. Only version 8.0 and later support guarantee timestamp.

Standard Security:

Provider=PostgreSQL OLE DB Provider;Data Source=yourServerAddress;location=yourDataBase;User ID=yourUsername;password=yourPassword;timeout=1000;

Note: You can use other provider values such as "PostgreSQL" and "PostgreSQL.1".