Access Linking Tables ODBC

Hi,

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).
(#2812)
**********************

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=10.0.11.15:4074;Initial Catalog=assumptions;User ID=hello;Password=hello;"
iamnamjaAsked:
Who is Participating?
 
Joe WoodhouseConnect With a Mentor Principal ConsultantCommented:
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)

=================



0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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?
0
 
iamnamjaAuthor Commented:
Hi,

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.
0
All Courses

From novice to tech pro — start learning today.