Error filling dataset with ODBC.NET
Ok, I'm going crazy with this one.
Can anyone tell me why I am getting the following error when running the below code?
ERROR:[IM001] [Microsoft][ODBC Driver Manager][Driver does not support this function]
This error comes up on executing the da.Fill... line
I have fully tested my ODBC connection to the database and it works perfectly, outside of the development environment.
*****************CODE*******************
string connString = "DSN=MMB";
string sqlString = "SELECT * FROM MB.T_MB_AGENT_SKILLS";
OdbcConnection conn = new OdbcConnection();
conn.ConnectionString = connString;
OdbcDataAdapter da = new OdbcDataAdapter(sqlString, conn);
DataSet ds = new DataSet();
da.Fill(ds, "T_MB_AGENT_SKILLS");
dataGrid1.DataSource = ds.DefaultViewManager;