I've been using ODBC to query for data from my companies sqlanywhere database, but recently a particular query failed.

My coworker has been using OleDB for similar transactions, and his query with the same sql string worked without issue.

So, I built a quick test in VB.Net 2002 using OleDB methods, and it also worked without issue.

So then I created the exact same test in .Net 2005, and it failed with the following error:

System.Data.OleDb.OleDbException: 'ASAProv' failed with no error message available, result code: DB_E_ERRORSOCCURRED(0x80040E21).
at System.Data.OleDb.OleDbDataReader.ProcessResults(OleDbHResult hr)
at System.Data.OleDb.OleDbDataReader.GetRowDataFromHandle()
at System.Data.OleDb.OleDbDataReader.GetValueBinding(MetaData info)
at System.Data.OleDb.OleDbDataReader.GetValue(Int32 ordinal)
at System.Data.OleDb.OleDbDataReader.get_Item(Int32 index)
at New_Ole.Form1.GET_TASK_PARM1(String mTaskID, String& mErrMsg) in C:\Documents and Settings\lou\My Documents\Visual Studio 2005\Projects\New_Ole\New_Ole\Form1.vb:line 87



However, if I run the 2005 program on my coworkers machine, it faultlessly works without issue.

We both installed 2005 at the same time, and as far as I can tell, we are both updated to the same level.

I am stumped as to how to what I should do to get this working.

HELP!

{BTW, the data I was trying to collect is only 8985 characters long, and the data format is a LONG VARCHAR}

-Lou