sp_odbc_tables
Rao Hanumara
problems with 11.9. client and odbc drivers. I do not remember installing
separate procedures for odbc drivers. We are currently have 12.5.1 on ASE
and odbc works fine with 11.5.x or 11.9.x client. When 12.5.1 client is
installed we run into these problems.
1. No connectivity though odbc is tested with oadbcad32 as connection
established without any problem.
2. get this message 'sp_odbc_tables' missing on the server.
3. Even if connected the transfer of data is dead slow.
We need to download data to Access and upload some stuff to ASE.
Any ideas? What I am missing here? If I reinstall 11.9. client, odbc works
fine.
Neal Stack
I think you will have better luck posting directly to the ODBC newsgroup:
news://forums.sybase.com:119/sybase.public.connectivity.odbc
But to get you started off, with 12.5.1 there are two sets of drivers provided:
1) Drivers manufactured by DataDirect
* Located in c:\sybase\ODBC
2) Drivers manufactured by Sybase
* Located in c:\sybase\DataAccess
It is recommended that you use the drivers manufactured by Sybase because
in version 15.0 we will only provide those drivers and it will make migrating
to 15 that much easier.
The ODBC Drivers need various stored procedures installed to help describe
meta-data. Look in the following directory for a script called
"install_odbc_sprocs.bat" and run it against your target server to install
the required stored procedures:
USAGE :install_odbc_sprocs myaseserver login1 pass1
Directory of C:\sybase\DataAccess\ODBC\sp
11/30/2006 09:21 AM <DIR> .
11/30/2006 09:21 AM <DIR> ..
01/04/2007 04:58 PM 886 getversion.sql
01/04/2007 04:58 PM 2,256 install_odbc_sprocs.bat
01/09/2007 09:29 PM 180,925 odbc_mda_120.sql
01/09/2007 09:29 PM 180,827 odbc_mda_125.sql
01/09/2007 09:29 PM 180,893 odbc_mda_12503.sql
01/09/2007 09:29 PM 180,888 odbc_mda_1251.sql
01/09/2007 09:29 PM 180,946 odbc_mda_150.sql
01/04/2007 04:58 PM 8,614 sp_drv_common.sql
01/04/2007 04:58 PM 8,226 sp_version.sql
Thanks,
Neal