DSN creation to DB2

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vandg@vandg.d2g.com - 15 Nov 2005 09:07 GMT

How can I create DSN to DB2 using IBM DB2 ODBC DRIVER

Reply to this Message

Dan Scott - 15 Nov 2005 13:29 GMT

www.connectionstrings.com is your friend:

Standard:
"driver={IBM DB2 ODBC
DRIVER};Database=myDbName;hostname=myServerName;port=myPortNum;protocol=TCPIP;
uid=myUserName; pwd=myPwd"

Dan

Reply to this Message

vandg@vandg.d2g.com - 15 Nov 2005 14:06 GMT

Thank you, Dan.
But I did not asked for connection string. I have this one but it takes
for connecting 30-40 seconds.. On the other hand the DSN connection
takes 1-2 seconds.
So, I want firstly create the DSN and then to use it to establish
connections.

Reply to this Message