By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,480 Members | 2,189 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,480 IT Pros & Developers. It's quick & easy.

ODBC Call Failed Error for Query using Linked Tables

P: 19
Hi,

Expand|Select|Wrap|Line Numbers
  1. SELECT TK_TURN_DAILY_DETAIL1.DATE, TK_TURN_DAILY_DETAIL1.USH_REVENUE AS TDL_Revenue, TK_TCK_SALE_DETAILS1.USH_REVENUE AS TSD_Revenue, [TSD_Revenue]-[TDL_Revenue] AS Expr1, TK_TCK_SALE_DETAILS1.TK_SERIAL AS TSD_TK_SERIAL, TK_TURN_DAILY_DETAIL1.TK_SERIAL AS TDL_TK_SERIAL, TK_TCK_SALE_DETAILS1.QTY_TIX_REP AS TSD_Quantity, TK_TURN_DAILY_DETAIL1.TCK_SCAN_QTY AS TDL_Quantity
  2. FROM TK_TCK_SALE_DETAILS1 RIGHT JOIN (TK_TURN_DAILY_DETAIL1 INNER JOIN TK_IMPORT_TICKET1 ON TK_TURN_DAILY_DETAIL1.TK_SERIAL = TK_IMPORT_TICKET1.TK_SERIAL_EXTERNAL) ON TK_TCK_SALE_DETAILS1.TK_SERIAL = TK_IMPORT_TICKET1.TK_SERIAL_INTERNAL
  3. WHERE (((TK_TURN_DAILY_DETAIL1.DATE)=[VARIANCE_DATE]) )
  4. ORDER BY TK_TURN_DAILY_DETAIL1.DATE;

When I run this query from MS Access, I get an 'ODBC Call Failed' error. I have created linked tables in access for the tables used in this query.

Anybody able to help me on this ?

Thanks in Advance.
Jul 23 '07 #1
Share this Question
Share on Google+
1 Reply


NeoPa
Expert Mod 15k+
P: 31,186
It's almost certainly nothing to do with your query (SQL) per se.
This is an ODBC problem. This is as varied as there are ODBC drivers out there, but I'd start by trying to open each of the tables in your query to see which of them has a problem. From there it's down to whoever at your company is responsible for the ODBC setup I'm afraid.
Jul 24 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.