ODBC ConnectionString

Question

I have written a program in C# to pull some data using OdbcConnection :

using System.Data.Odbc;
......

OdbcConnection OdbcConn = 
                new OdbcConnection(Properties.Settings.Default.ConnectionString);
OdbcCommand cmd = new OdbcCommand();

//open connection 
if (OdbcConn.State != ConnectionState.Open)
{
    OdbcConn.Open();
}

In my settings file, I have this ConnectionString:

Dsn=****;uid=userID;pwd=password

However I cannot establish a connection. I have an iseries access driver from IBM corp installed, but if I try MS access then I am able to connect. Any suggestions?

Answer 1

When in doubt (and it involves connections strings): http://www.connectionstrings.com/