ADO.NET and IBM DB2

LooBitel

New Member
I have just started playing with .net studio, but I am having problems connecting to my IBM DB2(version 7) database. I have been connecting to it in my COM objects like this:<BR><BR>Set adoServerConn = CreateObject("ADODB.Connection")<BR>sString = "DSN=DB Name;UID=xxxx;PWD=xxxx;"<BR>adoServerConn.ConnectionString = sString<BR>adoServerConn.Open<BR><BR>Now that I am using ADO.NET I am trying the following:<BR><BR>adoServerConn = New OleDb.OleDbConnection(sString)<BR>adoServerConn.Open()<BR><BR>How would my connection string look? That is where I am having problems.<BR><BR>I tried the following:<BR>sString = "Provider=DB2OLEDB;Initial _ <BR>Catalog=DB Name;UserID=xxx;Password=xxx"<BR><BR>Can anyone pleas help!!!!!!!!!<BR><BR>Thanks<BR>
 
Back
Top