invalid object name

[BFT1303]

I keep getting the following error when attempting to read a specific table in my database. The spelling of the table is correct and I have confirmed that it does exist in the database. Any suggestions?

S0002: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name <mytable name>. (-1)

 

[GeertVerhoeven]

Is it SQL 2005? If so check if there are no schemas involved. If so, use schema.object_name.

Geert Verhoeven
Consultant @ Ausy Belgium

My Personal Blog

 

[BFT1303]

It is SQL 2000, does that still apply?

 

[gmmastros]

Tables that have the same name as a reserved word, or contain spaces, should be wrapped in square brackets.

Ex:

[tt]
Select *
From [!][[/!]Table Name[!]][/!]
Where ....
[/tt]

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom