ODBC Connection Error

I'm getting the following error and detail when I try to pull data from an ODBC connection.  The table exists, and i can get to it through a different application using the same ODBC connection.  Any ideas?

Thanks!

Error:  (9020)

Details:  DBLMgr: ERROR [42S02] [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'TB_CORE_GENERAL_PROGRAM'.

-2146233088
LVL 2
corduroy9Asked:
Who is Participating?
 
udayshankarCommented:
make sure the owner of the table is prefixed.

or check if its not dbo
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Hi corduroy9,

Check
1. Whethe u have used the proper authentication for the connection
2: Incorrect object owner. Who owns the existing procedures
3: It is executed in the incorrect database.
0
 
udayshankarCommented:
check permission also
sp_helprotect null,'TB_CORE_GENERAL_PROGRAM'

and make sure you are uisng an account that has access to this table
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.