I am using ODBC to read the Northwind sample database via MSAccess 2000 and a bizarre problem occurs, but only when ODBC tracing is turned off!
Those tables which have primary keys based on string fields (e.g. Customers) report "memory allocation failed" when executing a select statement such as the following:
select * from Customers where CustomerID > ?
Some testing has shown that I can read the data OK from an exact copy of the table but not the original Northwind version. Its also really odd that it works with ODBC tracing turned on.
I have all the patches for MDAC 2.5, VC++ 6.0 and Windows 2000.
Does anybody have any suggestions?