PostgreSQL OLE DB Provider
This is a OLE DB Provider provided by PgOleDb Development Team.
The provider is contained in the file PgOleDb.dll.
The provider is contained in the file PgOleDb.dll.
Coding
Include "Provider=PostgreSQL OLE DB Provider" in the connection string to use this provider.
Description
This provider supports back end versions 7.4.x or above. Attempting to connect to a database running version 7.3.x or down will result in an error message saying "Couldn't query pg_type". Timestamps are only guarenteed to work with backends of version 8.0 and up.
In order to install this software, copy PGOLEDB.DLL and LIBPQ.DLL into your system directory. Next, as administrator, run "regsvr32 PGOLEDB.DLL". You should get a dialog message saying "registration succeeded".
If anything goes wrong, extended logging can be turned on for the provider. To turn on extended logging, modify in the registry the key: "HKEY_LOCAL_MACHINE\Software\PostgreSQL\OLE DB Provider". Under that key, create to values. One should be called "LogFile", and should specify full path (directory + filename) of the log file to create. The second should be "LogLevel" (type DWORD), and should specify what level of verbosity the logs should have. Setting it to "3" should give fairly complete coverage. When logging is no longer desired, please make sure to either remove or empty the "LogFile" value. Failing to do so may result in unnecessary disk space wasted.;
In order to install this software, copy PGOLEDB.DLL and LIBPQ.DLL into your system directory. Next, as administrator, run "regsvr32 PGOLEDB.DLL". You should get a dialog message saying "registration succeeded".
If anything goes wrong, extended logging can be turned on for the provider. To turn on extended logging, modify in the registry the key: "HKEY_LOCAL_MACHINE\Software\PostgreSQL\OLE DB Provider". Under that key, create to values. One should be called "LogFile", and should specify full path (directory + filename) of the log file to create. The second should be "LogLevel" (type DWORD), and should specify what level of verbosity the logs should have. Setting it to "3" should give fairly complete coverage. When logging is no longer desired, please make sure to either remove or empty the "LogFile" value. Failing to do so may result in unnecessary disk space wasted.;
More info about this provider can be found at the PgOleDb Development Team product page.
Connection Strings
Additional info or comments on this provider? Want to submit content?
Send an e-mail to
Send an e-mail to
Selected Articles