Boblysan

Boblysan

  • 0
  • 66
  • 0

Error filling dataset with ODBC.NET

Jun 25 2004 4:58 AM
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;