ODBC Query Problem

K

Kevin

I link my database to some AS400 based tables. Recently,
some queries have failed to run with the message "ODBC
call failed". However, I can open and view the tables
through Access.

Any ideas why I can view the tables, but not run a simple
select query on them?
 
J

Joe Fallon

Are you using Select * ?

Try Select Field1, Field2, etc.

But do it one field at a time until you get the failure so you can identify
it.
Probably has an incompatible data type.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sqlite-odbc write conflict 2
Trying to create a report that will list unmatched records by Ticket Primary Key 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Total parameter query and ODBC-call failed 0
I can create Publisher documents, but I can not open / read them. 0
Link to ODBC source with different DSN names 0
ODBC-Call Failed Office 2007 0
ODBC link to MySQL, can write, but not edit or delete 5

Top