postgresql connection string...펌

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.