I've got an ODBC connection through to a Sage database which connects without a problem, however when I try to perform any kind of commands on it I get the following exception:
System.Data.Odbc.OdbcException: ERROR [IM001] [Microsoft][ODBC Driver Manager] Driver does not support this function
at System.Data.Odbc.OdbcConnection.HandleError(HandleRef hrHandle, SQL_HANDLE hType, RETCODE retcode)
at ODBCTest.Form1.button1_Click(Object sender, EventArgs e) in c:\mydocuments\visual studios projects\odbctest\form1.cs:line 116
I've tried to query it using DataAdapter and also using a DataReader, and neither have worked. And I've had massive difficulty finding any help either on with Internet or with the Sage resellers!
So... Can anyone give me an idea of how to query a table in a Sage database using C#.NET with the ODBC connector?