Microsoft OLEDB provider for DB2 connection strings

Connects to

IBM DB2

  • TCP/IP

    Provider=DB2OLEDB;Network Transport Library=TCPIP;
    Network Address
    =xxx.xxx.xxx.xxx;Initial Catalog=MyCtlg;
    Package Collection
    =MyPkgCol;Default Schema=Schema;User ID=myUsername;
    Password
    =myPassword;
  • APPC

    Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote;
    Initial Catalog
    =MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;
    User ID
    =myUsername;Password=myPassword;
Problems connecting?
Get answer in the IBM DB2 Q & A forum
OLE DB ProviderProvider=DB2OLEDBInfo 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.