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