DB2 connection string

[chitrack]

Hi all,
I am really stuck with the connection string for DB2 thru ODBC. I fail connecting to thru ODBC/OLEDB too. I dont understand about the package collection. what does it mean?? Can anyone pls suggest me on this.

Thanks
Chitra

[exterminator]

See if this helps - All the connection strings you need (http://www.connectionstrings.com). For information about package collection you may refer to the specific DB2 reference manual that you might be having. Hope this helps. Regards.

[Shuja Ali]

Hi all,
I am really stuck with the connection string for DB2 thru ODBC. I fail connecting to thru ODBC/OLEDB too. I dont understand about the package collection. what does it mean?? Can anyone pls suggest me on this.

Thanks
Chitra
The site provided by abhishek is the best one to get all the connection strings. However, apart from using the connection string you will have to have tools installed on your system that will act as drivers.
You will have to install IBM DB2 UDB Drivers on your system or the IBM DB2 ODBC Drivers. Check the DB2 documentation for more details on this or ask you Systems guys to install one on your system.

[chitrack]

Thanks for the replies.
I have IBM DB2 ODBC provider and also MS ODBC provider for DB2. I could connect to the database with IBM DB2 provider as its very easy as far as the parameters are concerned. The MS provider expects many which I could not get thru. Even if I go thru the sites for connection string as mentioned by abhishek, there is nothing detailed esp for package collection = mypkgcol this how the information are written. I donno what is that mypkgcol how shud i do and all.