• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1050
  • Last Modified:

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
0
corduroy9
Asked:
corduroy9
  • 2
1 Solution
 
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

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now