IQ 16: Configure ASE 12.5.x Remote Server
When migrating from SAP Sybase IQ version 15.2 to version 16, if you had configured remote servers to SAP Sybase ASE 15.2.x using JDBC, you need to drop and recreate the remote servers using ODBC.
Test Environment
- SAP Sybase IQ 16 SP#1 on Solaris 10 64b running on Sun SPARC 64-bit.
- SAP Sybase ASE 12.5.3 ESD#7 on Solaris 8 64b running on Sun SPARC 64-bit.
Procedure Overview
- Install and configure Sybase ODBC driver on the SAP Sybase IQ server.
- Upgrade the DMA scripts on the ASE server.
- Configure the ODBC Data Source Name.
- Drop and recreate the remote server in SAP Sybase IQ.
Procedure
Install and configure Sybase ODBC driver on the SAP Sybase IQ server
- Download the last SDK from SAP download website.
- Uncompress the SDK in a temporary folder.
- Go into the ebf* folder.
- Verify that $SYBASE variable is properly set.
- Launch the installer (setup.bin), and click “Next” on the introduction screen.
- Select your geographic region; read and agree with the terms of the license and click on “Next”.
- Specify the folder where the ODBC driver will be installed and click “Next”
- If is a new folder, click “Yes” to accept the creation of the new folder
- Since we are only interested in installing the ODBC driver, select “Custom” and click “Next”
- Select “ASE ODBC Driver” and deselect everything else, click on “Next’
- Review the pre-installation summary and press “Install”
- Click on “Done” when the installation is completed
- Verify that you have the following soft links to the driver manager, create this soft links if necessary:
/usr/lib/libodbc.so -> libodbc.so.1
/usr/lib/libodbcinst.so -> libodbcinst.so.1









Upgrade the DMA scripts on the ASE server
- Verify the current version of the ODBC MDA scripts on the SAP Sybase ASE 12.5.x server.
sp_version
Script Version Status
————————– —————————————————– ———
ODBC MDA Scripts 12.5.1.500/Fri 12-23-2005 12:59:25.57 Complete - If the version of the scripts is lower that the version of the drivers just installed, update the scripts
- On the SAP Sybase IQ Server, Go to $SYBASE/DataAccess64/ODBC/sp folder and execute install_odbc_sprocs (You can also copy the sp folder to a temporary location on the SAP Sybase ASE server and execute install_odbc_sprocs from this location).
- Verify if the installation was successful
sp_version
Script Version Status
————————– ——————————————————————- ———
ODBC MDA Scripts 15.7.0.1100.1012/Wed Jul 31 UTC 01:24:40 2013 Complete
Install_odbc_sprocs <ASE server name> <ASE user> <ASE password>
Configure the ODBC Data Source Name
- Add the path of the ASE ODBC driver library to the LD_LIBRARY_PATH (or LD_LIBRARY_PATH_64) environment variable
- Add the new DSN to the .odbc.ini file
[ODBC Data Sources]
<Other data sources>
mydwetldev01 = Sybase ODBC data source<Other data sources>
[mydwetldev01]
Description=Sybase ODBC Data Source
Driver=/IQ/Server/IQ-16/ODBC/DataAccess64/ODBC/lib/libsybdrvodb.so
Server=mydwetldev01
Port= 4610
Database=testStageDb
UseCursor=1
Drop and recreate the remote server in SAP Sybase IQ
- Drop the old remote server
- Re-create the server using the class ‘ASEODBC’
create server Mydwetldev01
class ‘aseodbc’
using ‘driver=/IQ/Server/IQ-16/ODBC/DataAccess64/ODBC/lib/libsybdrvodb.so;dsn=Mydwetldev01’
- Test connectivity
drop server Mydwetldev01
forward to Mydwetldev01 { select @@servername, db_name(), @@version };
References
- Sybase SDK 15.7 sample readme.txt
- Hansen, Ryan; SAP Sybase Adaptive Server Enterprise Developer Center; in response of “Can I use the SAP Sybase ODBC driver in ASE SDK 15.7 to connect to ASE 12.5.3 ESD#7?” (2013, October 23) Retrieved from http://scn.sap.com/message/14463777#14463777
- Gvirtzm Leonid; “IQ 15.2 and ASEODBC on Unix” [Blog post]; (2010, November 29) Retrieved from http://leonid-gvirtz.typepad.com/blog/2010/11/iq-152-and-aseodbc-on-unix.html