Skip to content

IQ 16: Configure ASE 12.5.x Remote Server

October 25, 2013

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

  1. Install and configure Sybase ODBC driver on the SAP Sybase IQ server.
  2. Upgrade the DMA scripts on the ASE server.
  3. Configure the ODBC Data Source Name.
  4. Drop and recreate the remote server in SAP Sybase IQ.

Procedure

Install and configure Sybase ODBC driver on the SAP Sybase IQ server

  1. Download the last SDK from SAP download website.
  2. Uncompress the SDK in a temporary folder.
  3. Go into the ebf* folder.
  4. Verify that $SYBASE variable is properly set.
  5. Launch the installer (setup.bin), and click “Next” on the introduction screen.
  6. Select your geographic region; read and agree with the terms of the license and click on “Next”.
  7. Specify the folder where the ODBC driver will be installed and click “Next”
  8. If is a new folder, click “Yes” to accept the creation of the new folder
  9. Since we are only interested in installing the ODBC driver, select “Custom” and click “Next”
  10. Select “ASE ODBC Driver” and deselect everything else, click on “Next’
  11. Review the pre-installation summary and press “Install”
  12. Click on “Done” when the installation is completed
  13. 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

  1. 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

  2. If the version of the scripts is lower that the version of the drivers just installed, update the scripts
  3. 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).
  4. Install_odbc_sprocs <ASE server name> <ASE user> <ASE password>

  5. 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

Configure the ODBC Data Source Name

  1. Add the path of the ASE ODBC driver library to the LD_LIBRARY_PATH (or LD_LIBRARY_PATH_64) environment variable
  2. 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

  1. Drop the old remote server
  2. drop server Mydwetldev01

  3. 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’

  4. Test connectivity
  5. forward to Mydwetldev01 { select @@servername, db_name(), @@version };

References

  1. Sybase SDK 15.7 sample readme.txt
  2. 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
  3. 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

Advertisements

From → ODBC, SAP IQ, Sybase ASE, UNIX

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: