PostgreSQL OLE DB Provider connection strings

Connects to

PostgreSQL

  • 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"

  • 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;
Problems connecting?
Get answer in the PostgreSQL Q & A forum
OLE DB ProviderProvider=PostgreSQL OLE DB ProviderInfo and provider downloads

Providers

Connect

Articlesread all »

Didn't find your connection string?

Start over from the connection string reference index - or try a search!

In the Q&A forums you can ask your own question and let somebody help you.

The knowledge articles contains solutions and guides.