469,963 Members | 2,086 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,963 developers. It's quick & easy.

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

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
0 4603

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

4 posts views Thread by GAVO-UK | last post: by
7 posts views Thread by aacool | last post: by
6 posts views Thread by Jon Davis | last post: by
1 post views Thread by Chris Love | last post: by
1 post views Thread by rainxy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.