Using FileMaker Pro odbc driver with FM Pro 6

[faifaila]

I'm new to FM Pro. I'm doing sql select from an application on a table using the FileMaker Pro odbc driver. I am able to get results if the set is small by using the where clause to minimize the result set. I want to get the entire table however. When I take out the where clause to get the table it appears that the odbc driver is timing out. I get the error message, 'An attempt to fetch forward has failed for table: xxxx'.

FM Pro version is 6.0. The driver version is 3.60. It's a c#.NET application. I'm using

OdbcDataAdapter.

I would appreciate any advice. Thanks in advance.