Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  New to SQL Server Programming  how to prepare ole db connection string for DB2

Author  Topic  GarySQL Starting Member 1 Post Posted - 2010-09-22 : 11:59:59 Microsoft OLE DB connection look like as below Provider=DB2OLEDB;Network Transport Library=TCPIP;Network Address=xxx.xxx.xxx.xxx;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=sa;Password=myPassword; How can I get "default Schema", and "Package Collection"? I guess "Initial Catalog" is database name. I have installed DB2 developer version 9.7 for window. It used Microsoft OLE DB connection to access DB2. But I can't construct connection string. thanks Gary