ODBC--call failed

[TJVFree]

I’ve been trying to do a basic pass thought query. But have been receiving these two error messages


1.ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'my tabel name' (#102)
Error message

2. ODBC--call failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'my tabel name' (#208)


Basic Query
SELECT dbo_VC_Admin.app_num
FROM dbo_VC_Admin;

When trying to open the server table
a. ODBC--call failed. [Microsoft][ODBC SQL Server Driver]Timeout expired (#0)


I don’t have access to change my regedit:
HKEY_LOCAL_MACHINE\Software\Microsoft\Jet\4.0\Engines\ODBC

So Is there another way to fix this error?


Thanks for your help

 

[Hap007]

Have you set the ODBC Connection String for the Pass Through query?

You must do this for each pass through query you create.

Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[TJVFree]

Yes I have

 

[dhookom]

You wouldn't typically use "dbo_" in a pass-through. Try:

SELECT VC_Admin.app_num
FROM VC_Admin

or

SELECT VC_Admin.app_num
FROM dbo.VC_Admin

Duane
Hook'D on Access
MS Access MVP