ODBC Connection Error

Posted on 2006-03-24
Last Modified: 2011-08-18
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?


Error:  (9020)

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

Question by:corduroy9
    LVL 9

    Accepted Solution

    make sure the owner of the table is prefixed.

    or check if its not dbo
    LVL 75

    Expert Comment

    by:Aneesh Retnakaran
    Hi corduroy9,

    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.
    LVL 9

    Expert Comment

    check permission also
    sp_helprotect null,'TB_CORE_GENERAL_PROGRAM'

    and make sure you are uisng an account that has access to this table

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Introduction In my previous article ( I showed you how the XML Source component can be used to load XML files into a SQL Server database, us…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
    Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.

    728 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now