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