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;
=myDataBase;User ID=myUsername;password=myPassword;timeout=1000;

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


This connection string (Standard using PgOleDb) can be used for connections to PostgreSQL.

Articlesread all »

Not the right connection string for you?

Start over in the connection string reference index.

You can also get help in the Q&A forums where you can ask your own question.

The kb articles contains how-tos and instructions and you can search for anything if you're not sure were to look.