ODBC--call failed

[TCB]

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\Engi nes\ODBC

So Is there another way to fix this error?




Thanks for your help

[ajetrumpet]

I assume you mention regedit because you've search the MS sites and they're telling you to change a key's value?

that's one serious problem with ms sites. the "goto" seems to be the registry, which is completely ridiculous.

[TCB]

Do you know how I can fix this?

[ajetrumpet]

i would assume the error is legit. there is no one common fix for things like this.

I can tell you though,l that if you type that stuff into google, you'll get so many returns back that it'll take you all day to look through them all.

have you tried researching the obvious? You didn't mention that. the errors are pretty clear.

[NoellaG]

Hi TCB,

it could be you do not have enough rights on the SQL server table. Have you tried the connection? You can do this from within the administrative tools.

greetings
NG