Previous Topic

Next Topic

Book Contents

Book Index

Connecting to Sybase

These notes were written for Sybase v12.5, and the Sybase ODBC Driver SYODASE.DLL.

Prerequiste Software

In order to connect to a Sybase database, you need to install the Sybase Client. When you install this, make sure the ODBC Driver is selected as part of the install.

Configuring the Sybase ODBC Driver

In order to access your Sybase 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:

In addition, there are some settings on the Performance tab which we recommend you set:

It is recommended that you click on Test Connect to ensure that your connection has been configured correctly.

AQT Options

In addition, we recommend you set the AQT Option > Technical Parameters > For Sybase and SQL Server, use SET ROWCOUNT. This is discussed in more detail in Rowcount for SQL Server and Sybase.

Advanced Query Tool
https://www.querytool.com
© 2023 Cardett Associates Ltd. All rights reserved.