By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,494 Members | 1,079 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,494 IT Pros & Developers. It's quick & easy.

What's the DB2 connection string wihout DSN when use IBM DB2 OLE PROVIDER in windows environment?

P: n/a
What's the DB2 connection string wihout DSN when use IBM DB2 OLE
PROVIDER in windows environment, such as ADO or Creation of Linked
Server in MS SQL Server ?

I searched for a long time to look for a connection string wihout DSN
using IBM DB2 OLE PROVIDER in windows environment, but unfortunately, I
found none.

The DB2 connection string in http://www.connectionstring.com/ is
wrong:
Provider=IBMDADB2;Database=sample;HOSTNAME=db2host ;PROTOCOL=TCPIP;PORT=50000;uid=myUserName;pwd=myPw d;
I can't use it when use sp_addlinkedserver (the MS SQL Server Stored
Procedure) which needs a connection string to create a linked DB2
server item.

The connection string with DSN can work, but I just want a connection
string withou DSN, because not every one likes to use DSN. Is it
possible?

Any hint will be appreciated. Thanks.

Regards.
Ling, Xiao-li

Aug 17 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.