Can I use the SAP Sybase ODBC driver in ASE SDK 15.7 to connect to ASE 12.5.3 ESD#7?

[Former Member]

I’m trying to connect to an instance of “Adaptive Server
Enterprise/12.5.3/EBF 13325 ESD#7/P/Sun_svr4/OS 5.8/ase1253/1951/64-bit/FBO/Fri
Mar 24 11:00:22 2006” using ODBC.  Can I
use the ODBC driver provided with SDK 15.7 or should I use and early version of
the SDK?

[ryan_hansen · Accepted solution]

Hi Uvernes Somarriba,

This is something that isn't tested as ASE 12.5.3 was EOL before SDK 15.7.

We do have some customers using old ASEs with newer clients.

This might work depending on what you are doing.

Here is what you need to do before testing.

Update the MDA scripts.

These scripts might not be installed on the ASE currently as it is an older version.

However these MDA scripts keep the SDK drivers compatible with the ASEs.

To see what version of scripts are currently installed isql into the ASE.

run command:

sp_version

At the top of the output you should see:

ODBC MDA Scripts

        xx.x.x.xxx/date

If this command fails then there are no scripts currently installed.

To keep the Driver compatible with the ASE the scripts must be >= the driver used.

To update/create the scripts a batch job is used.

This batch job is located in $SYBASE/DataAccess/ODBC/sp

install_odbc_sprocs

Example of running this:

install_odbc_sprocs <sql.ini entry> sa <password>

To update my server I use-

install_odbc_sprocs solex sa sybase

This will install the scripts on the ASE.

When running sp_version again it should output the new version.

These scripts are backward compatible.

Once this is done you can test the ODBC driver against ASE 12.5.3.

Let me know if you have questions.

Regards,

Ryan

[Former Member · Accepted solution]

Thanks a lot Ryan, will test and get back with the resutls.

[Former Member · Accepted solution]

It worked well.  Here is what I was trying to accomplish: "IQ 16: Configure ASE 12.5.x Remote Server" http://wp.me/p1Gouv-66

Thanks a lot!