Hello guys! I have a problem with queries in MS Access 2003! The problem appears when I launch some more difficult query and then for example try to sort the result by some of the fields. The error message I get is “ODBC–connection to ‘MyConnection’ failed” or sometimes “ODBC–call failed”. If I close/open MS Access, everything starts to work until next error takes place. The most interesting thing is that error usually shows when launching more complex queries=>with easy queries everything looks much better but if I sort the easy one more than once then it stops working too! My presumption is that problem is in some kind of cache ore buffer that gets full! Please, give me some clue! Situation: Navision 3.7,MS Access 2003, Query using Navision linked tables
What exact version of C/ODBC are you using ?
Thomas, according to Windows ODBC information I am using version No. 3.70.00.14988 (came with first release). Why are you asking? Do you want to say that I need to try some newer one?
Now I have tried it with C/ODBC version 3.70.02.19516 (came with 3.70 B)… Nothing changed[B)].
Take into account that the Navision ODBC has a 250 character restriction on the query string length… don’t know if this can be the case with your complex quieres. In my case, I had to rename a couple of fields, in order to make the query string shorter… Saludos Nils
Did you try to replace the fieldname with the string “FIELD2” for field ID 2 ? This works inside C/AL and also when setting filters !!! I.e. SETVIEW() command. I could imagine that it also works with ODBC
I had same problem - got round it by creating new table from odbc data and then running query on that.