Access Linking Tables ODBC

Posted on 2009-12-18
Last Modified: 2013-11-27

I'm trying to link a table that exists externally.  I tried to setup ODBC connection, and I get the following error:
ODBC--call failed.
[Sybase][ODBC Driver][Adaptive Server Enterprise]Stored procedure 'sp_odbc_tables' not found.  Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

I have no problem connecting and fetching queries using ADODB connection.  But I have found that doing it this way takes too long to fetch the query, and saving the values into the table in the database.  Any suggestions on how I can link the table?

The connection string that i use to connect using the ADODB connection is:

"Provider=ASEOLEDB;Data Source=;Initial Catalog=assumptions;User ID=hello;Password=hello;"
Question by:iamnamja
    LVL 84
    Are you certain your user has the necessary permissions to use the table and stored procedure?

    Is sp_odbc_tables a STored Procedure you built? If so, are you sure the "hello" user has permissions to execute that SP?

    Author Comment


    Hello user has permissions to access the tables.  Although I'm not sure about the stored procedures.

    I believe the stored procedure that the error is mentioning is something that is on serverside, and something that is automatically run to "fetch" the tables?
    This is the conclusion that I've come to as I have no problem acceessing and fetching the neeeded queries suing the ADODB, but can't get anything when i try to link the tables.
    LVL 24

    Accepted Solution

    This is a known issue caused by changes to how the ODBC (and OLE) drivers for Sybase work. Short answer, there is a file you need to run (from your client machine where the ODBC is installed) against your Sybase server.

    ====From the ODBC ebf coverletter====

    * Installing Meta-Data stored procedures required by new ODBC and OLE DB Drivers on Adaptive Server Enterprise

    You will need to install the ODBC/OLE DB Meta-Data stored procedures on any Adaptive Servers that you will connect to using the new ASE ODBC Driver by Sybase or the new ASE OLE DB Provider by Sybase. To install the stored procedures, go the "sp" directory under the ODBC/OLE DB installation directory and execute the install script in that directory. Names of the script are install_odbc_sprocs for ODBC Driver and install_oledb_sprocs for OLE DB Provider.

    Syntax for using the script is:

    install_[odbc/olebd]_sprocs <ServerName> <username> [<password>]

    where <ServerName> is the name of the Adaptive Server

    <username> is the username to connect to the server

    [<password>] is the password the username

    (don't supply this for null password)



    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
    Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

    755 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

    22 Experts available now in Live!

    Get 1:1 Help Now