SQL Query on ODBC Driver returns strange error...

[icegaze]

I am receiving the error message "S1000: [FileMaker][ODBC FileMaker Pro driver]An attempt to fetch forward has failed for table: PRODUCTS" when executing a SQL Query on my VB application (I am using the ODBC Driver packaged with FMPro 6)

strSQL = "SELECT DISTINCT * FROM Products WHERE ProductType <> 'Mati

[_ian]

How large are the contents of the fields returned in response to this query? Perhaps there is a limit to the size of data that can be returned by the driver. The fact that this only happens for some records suggests that there is something in the data of those records that may cause the problem.

Does the problem still happen if you specify some of the fields instead of saying "select * from ..."?

[icegaze]

I tried restricting my query to one field that is 6 characters long but the problem still happen. I also checked the content of that field in FileMaker to make sure that the content of the field is alright and everything seem ok. I am beginning to think that the ODBC drive is the problem...