Using the Sage ODBC Connection with C#.NET

Hi,

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 System.Data.Odbc.OdbcDataReader.NextResult()
   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?

Cheers,

Ged
gedmattAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
moduloConnect With a Mentor Commented:
PAQed, with points refunded (250)

modulo
Community Support Moderator
0
 
gedmattAuthor Commented:
Crikey! Answered my own question again!

The version of Sage I am accessing only allows reading and not writing, do using a DataAdapter is out. So I used a DataReader to source the data but still ended up getting the above error message.

Well on closer examination I found that with the DataReader I could get any data I needed, but for some reason I still get an exception thrown when I try to close it. Peculiar, maybe, but it "works" so I don't care...

Ged
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.