ODBC connection

[cBarry263]

I want to connect to a DB2 database with a traditional, already defined ODBC connection. I know that I could do something like this: "driver={IBM DB2 ODBC DRIVER};Database=myDbName;hostname=myServerName;port=myPortNum;protocol=TCPIP; uid=myUserName; pwd=myPwd".However I have been told not to do it this way, because all of this information (except the userName and passWord) is already provided in the ODBC connection setup (administrative tools -> ODBC). Does anyone know how to do this?

 

[kulrom]

Well if you have a ODBC (DSN) defined already connection then you can just use "DSN=dsnName" as the connection string i.e

Dim myConn as OdbcConnection = new OdbcConnection("DSN=myDB2")
myConn.Open()

HTH
Regards

 

[DavidT_macktool]

Nice link for connection strings: DB2 included.

http://www.connectionstrings.com/