I am currently connecting to a MaxDB 7.5.00 with ODBC driver 7.5.00.10, and trying to get MS Access to work with the tables.
I am able to link the tables fine, and can open them and manipulate the data fine.
But if I create any queries (even as simple as SELECT * FROM whatever) that result in more than 100 entries, Access reports "ODBC call failed".
If I look in the trace, I get
---------
MASS STATEMENT : FETCH "SQL_CURSOR_0287"
EXECUTE: CMD : PARSEID: INPUT : 000003E5 00001B01 2A002B00 01000000
SQLCODE: 100 ROW NOT FOUND
START : DATE : 2004-03-05 TIME : 0010:42:39
END : DATE : 2004-03-05 TIME : 0010:42:39
---------
In particular I was testing with a SELECT * on a table with 100 records, and it worked.. If I add another record it fails.
Any ideas? Is this an MS Access problem or a MaxDB ODBC problem?
Derek Hinchliffe -- IT Administrator MPL Group Ph: (08) 9355 7191 Mop: 0409 116 602 Fax: (08) 9355 7111
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
