These notes were written for SAP ASE v16.0, and the SAP ASE ODBC Driver SYBDRVODB.DLL.
SAP ASE was previously known as Sybase ASE.
Prerequiste Software
In order to connect to a SAP ASE database, you need to install the SAP ASE Client. When you install this, make sure the ODBC Driver is selected as part of the install.
Configuring the SAP ASE ODBC Driver
In order to access your SAP ASAE server using AQT, you will need to configure an ODBC Datasource for your server. The general process for doing this is described in Configuring a Database Connection.
To configure this, specify:
Datasource Name. The name you give this ODBC datasource.
Description. Not used. Leave blank.
Server Name. Specify the network name of the server on which the SAP ASE database resides. Use localhost is it the same machine as your client
Server Port: The port number the database is listening on. You may need to consult your DBA for this info. The default port for SAP ASE is 5000 but your server may have been configured to use a different one.
Database Name. The name of the database you are to connect to. Leave blank to connect to the default database.
BackEnd Type: ASE
In addition, there is a settings on the Advanced tab which we recommend you set:
Fetch Array Size Increasing the value beyond the default can improve performance quite noticeably. We suggest a value of 200 or higher. The optimum value of this settings depends on your network configuration and amount of data you commonly query
It is recommended that you click on Test Connect to ensure that your connection has been configured correctly.
