Standard using PgOleDb
This PostgreSQL OLE DB Provider connection string can be used for connections to PostgreSQL.
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;
Other valid Provider values is "PostgreSQL" and "PostgreSQL.1"