Purpose
The purpose of this article is to explain the ability to install multiple versions of the Sybase SDK on a single machine.
Overview
Sometimes, for testing purposes and upgrades, two different versions of the Sybase SDK may be required on a single machine. For instance, an
application that currently is using version 15.5 of the SDK needs to be upgraded to version 15.7. The application still needs to be able to perform
it's normal functionality while testing the new version of the Sybase libraries. By installing two versions of the SDK on the same machine, this
would allow for both versions to be used for both purposes.
Running different versions of SDK on Windows
In a heterogeneous environment that uses applications built for different versions of SDK, you must explicitly set a path for each version at the
Command Prompt window. Please note that you need to start the Command Prompt as administrator to update registry entries.
In the following example, applications using the 12.5.x products are installed in the d:\ocs-1251 directory, and applications using the 15.7 products
are installed in the d:\ocs-15_0 directory:
12.5.x
- To use SDK 12.5.x, open a Command Prompt window and set the SYBASE and SYBASE_OCS environment variables to the 12.5.x directory.
For example:- set SYBASE=D:\ocs-1251
- set SYBASE_OCS=OCS-12_5
- In the same Command Prompt window, set the PATH environment variable to the 12.5.x directory.
- On Microsoft Windows x86 32-bit: set PATH=%SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\%SYBASE_OCS%\dll;%SYBASE%\%SYBASE_OCS%\lib3p;%PATH% On Microsoft Windows x86-64 64-bit: set PATH=%SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\%SYBASE_OCS%\dll;%SYBASE%\%SYBASE_OCS%\lib3p64;%SYBASE%\%SYBASE_OCS%\lib3p;%PATH%
15.0
- To use SDK 15.0, open another Command Prompt window and set the SYBASE and SYBASE_OCS environment variables to the 15.7directory.
- For example: set SYBASE=C:\SDK150
- set SYBASE_OCS=OCS-15_0
- In the same Command Prompt window, set the PATH environment variable. For example:
- For example: On Microsoft Windows x86 32-bit: set PATH=%SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\%SYBASE_OCS%\dll; %SYBASE%\%SYBASE_OCS%\lib3p;%SYBASE%\DataAccess\ADONET\dll;%SYBASE%DataAccess\ODBC\dll;%SYBASE%\DataAccess\OLEDB\dll%PATH%
On Microsoft Windows x86-64 64-bit: set PATH=%SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\%SYBASE_OCS%\dll;SYBASE%\DataAccess\ADONET\dll;SYBASE%\DataAccess64\ADONET\dll;%SYBASE%DataAccess\ODBC\dll;%SYBASE%\DataAccess64\ODBC\dll;%SYBASE%\%SYBASE_OCS%\lib3p64;%SYBASE%\%SYBASE_OCS%\lib3p;%PATH%
- For example: On Microsoft Windows x86 32-bit: set PATH=%SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\%SYBASE_OCS%\dll; %SYBASE%\%SYBASE_OCS%\lib3p;%SYBASE%\DataAccess\ADONET\dll;%SYBASE%DataAccess\ODBC\dll;%SYBASE%\DataAccess\OLEDB\dll%PATH%
- Set the include location
- set INCLUDE=C:\;%SYBASE%\%SYBASE_OCS%\include
- set the Lib
- set LIB=%SYBASE%\%DataAccess\ADONET\dll;%SYBASE%\DataAccess64\ADONET\dll%SYBASE%\%SYBASE_OCS%\lib;
- Manually register the drivers you need This is for the 64 bit drivers
- C:\Windows\System32\regsvr32 C:\$SYBASE\DataAccess64\OLEDB\dll\sybdrvoledb.dll
- C:\Windows\System32\regsvr32 C:\$SYBASE\DataAccess64\ODBC\dll\sybdrvodb64.dll This is for the 32 bit drivers
- C:\Windows\SysWOW64\regsver32 C:\$SYBASE\DataAccess\OLEDB\dll\sybdrvoledb.dll
- C:\Windows\SysWOW64\regsver32 C:\$SYBASE\DataAccess\ODBC\dll\sybdrvodb.dll
15.5
- To use SDK 15.5, open another Command Prompt window and set the SYBASE and SYBASE_OCS environment variables to the 15.7directory.
- For example: set SYBASE=C:\SDK155
- set SYBASE_OCS=OCS-15_0
- In the same Command Prompt window, set the PATH environment variable. For example:
- For example: On Microsoft Windows x86 32-bit: set PATH=%SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\%SYBASE_OCS%\dll; %SYBASE%\%SYBASE_OCS%\lib3p;%SYBASE%\DataAccess\ADONET\dll;%SYBASE%DataAccess\ODBC\dll;%SYBASE%\DataAccess\OLEDB\dll%PATH%
On Microsoft Windows x86-64 64-bit: set PATH=%SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\%SYBASE_OCS%\dll;SYBASE%\DataAccess\ADONET\dll;SYBASE%\DataAccess64\ADONET\dll;%SYBASE%DataAccess\ODBC\dll;%SYBASE%\DataAccess64\ODBC\dll;%SYBASE%\%SYBASE_OCS%\lib3p64;%SYBASE%\%SYBASE_OCS%\lib3p;%PATH%
- For example: On Microsoft Windows x86 32-bit: set PATH=%SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\%SYBASE_OCS%\dll; %SYBASE%\%SYBASE_OCS%\lib3p;%SYBASE%\DataAccess\ADONET\dll;%SYBASE%DataAccess\ODBC\dll;%SYBASE%\DataAccess\OLEDB\dll%PATH%
- Set the include location
- set INCLUDE=C:\;%SYBASE%\%SYBASE_OCS%\include
- set the Lib
- set LIB=%SYBASE%\%DataAccess\ADONET\dll;%SYBASE%\DataAccess64\ADONET\dll%SYBASE%\%SYBASE_OCS%\lib;
- Manually register the drivers you need
This is for the 64 bit drivers- C:\Windows\System32\regsvr32 C:\$SYBASE\DataAccess64\OLEDB\dll\sybdrvoledb.dll
- C:\Windows\System32\regsvr32 C:\$SYBASE\DataAccess64\ODBC\dll\sybdrvodb64.dll
This is for the 32 bit drivers - C:\Windows\SysWOW64\regsver32 C:\$SYBASE\DataAccess\OLEDB\dll\sybdrvoledb.dll
- C:\Windows\SysWOW64\regsver32 C:\$SYBASE\DataAccess\ODBC\dll\sybdrvodb.dll
15.7
- To use SDK 15.7, open another Command Prompt window and set the SYBASE and SYBASE_OCS environment variables to the 15.7directory.
- For example: set SYBASE=C:\SDK157
- set SYBASE_OCS=OCS-15_0
- In the same Command Prompt window, set the PATH environment variable. For example:
- For example: On Microsoft Windows x86 32-bit: set PATH=%SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\%SYBASE_OCS%\dll; %SYBASE%\%SYBASE_OCS%\lib3p;%SYBASE%\DataAccess\ADONET\dll;%SYBASE%DataAccess\ODBC\dll;%SYBASE%\DataAccess\OLEDB\dll%PATH%
On Microsoft Windows x86-64 64-bit: set PATH=%SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\%SYBASE_OCS%\dll;SYBASE%\DataAccess\ADONET\dll;SYBASE%\DataAccess64\ADONET\dll;%SYBASE%DataAccess\ODBC\dll;%SYBASE%\DataAccess64\ODBC\dll;%SYBASE%\%SYBASE_OCS%\lib3p64;%SYBASE%\%SYBASE_OCS%\lib3p;%PATH%
- For example: On Microsoft Windows x86 32-bit: set PATH=%SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\%SYBASE_OCS%\dll; %SYBASE%\%SYBASE_OCS%\lib3p;%SYBASE%\DataAccess\ADONET\dll;%SYBASE%DataAccess\ODBC\dll;%SYBASE%\DataAccess\OLEDB\dll%PATH%
- Set the include location
- set INCLUDE=C:\;%SYBASE%\%SYBASE_OCS%\include
- set the Lib
- set LIB=%SYBASE%\%DataAccess\ADONET\dll;%SYBASE%\DataAccess64\ADONET\dll%SYBASE%\%SYBASE_OCS%\lib;
- Manually register the drivers you need
This is for the 64 bit drivers- C:\Windows\System32\regsvr32 C:\$SYBASE\DataAccess64\OLEDB\dll\sybdrvoledb.dll
- C:\Windows\System32\regsvr32 C:\$SYBASE\DataAccess64\ODBC\dll\sybdrvodb64.dll
This is for the 32 bit drivers - C:\Windows\SysWOW64\regsver32 C:\$SYBASE\DataAccess\OLEDB\dll\sybdrvoledb.dll
- C:\Windows\SysWOW64\regsver32 C:\$SYBASE\DataAccess\ODBC\dll\sybdrvodb.dll
16.0
- To use SDK 16.0, open another Command Prompt window and set the SYBASE and SYBASE_OCS environment variables to the 15.7directory.
- set SYBASE=SDK16
- set SYBASE_OCS=OCS-16_0
- In the same Command Prompt window, set the PATH environment variable.
For example: On Microsoft Windows x86 32-bit:
set PATH=%SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\%SYBASE_OCS%\dll; %SYBASE%\%SYBASE_OCS%\lib3p;%SYBASE%\DataAccess\ADONET\dll;%SYBASE%DataAccess\ODBC\dll;%SYBASE%\DataAccess\OLEDB\dll%PATH%
On Microsoft Windows x86-64 64-bit: set PATH=%SYBASE%\%SYBASE_OCS%\bin;%SYBASE%\%SYBASE_OCS%\dll;SYBASE%\DataAccess\ADONET\dll;SYBASE%\DataAccess64\ADONET\dll;%SYBASE%DataAccess\ODBC\dll;%SYBASE%\DataAccess64\ODBC\dll;%SYBASE%\%SYBASE_OCS%\lib3p64;%SYBASE%\%SYBASE_OCS%\lib3p;%PATH% - Set the include location
set INCLUDE=C:\;%SYBASE%\%SYBASE_OCS%\include - set the Lib
set LIB=%SYBASE%\%DataAccess\ADONET\dll;%SYBASE%\DataAccess64\ADONET\dll%SYBASE%\%SYBASE_OCS%\lib; - Manually register the drivers you need
This is for the 64 bit drivers- C:\Windows\System32\regsvr32 C:\$SYBASE\DataAccess64\OLEDB\dll\sybdrvoledb.dll
- C:\Windows\System32\regsvr32 C:\$SYBASE\DataAccess64\ODBC\dll\sybdrvodb64.dll
This is for the 32 bit drivers - C:\Windows\SysWOW64\regsver32 C:\$SYBASE\DataAccess\OLEDB\dll\sybdrvoledb.dll
- C:\Windows\SysWOW64\regsver32 C:\$SYBASE\DataAccess\ODBC\dll\sybdrvodb.dll
Although you must install different versions in separate directories, you can maintain a single sql.ini file by explicitly passing the address file name
to each application, for example: isql -P -Usa -Sconnect50 -ID:\ocs-150\ini\sql.ini for a ctlibs application
Related Content
Related Documents
Sybase Software Developers Kit Release Bulletin
Related SAP Notes /KBAs