A server with server class aseodbc is:
Adaptive Server Enterprise
SQL Server (version 10 and later)
Sybase IQ requires the local installation of the Adaptive Server Enterprise ODBC driver and Open Client connectivity libraries to connect to a remote Adaptive Server with class aseodbc. However, the performance is better than with the asejdbc class.
Open Client should be version 11.1.1, EBF 7886 or above. Install Open Client and verify connectivity to the Adaptive Server before you install ODBC and configure Sybase IQ. The Sybase ODBC driver should be version 11.1.1, EBF 7911 or above.
If the data resides on a 64-bit system, the aseodbc class is unavailable because no UNIX-based ODBC driver for ASE exists. Use the asejdbc class instead.
Configure a User Data Source in the ODBC Data Source Administrator with the following attributes:
On the ODBC tab:
Enter any value for Data source name. This value is used in the USING clause of the CREATE SERVER statement.
On the Database tab:
Server name should match the name of the server in the Sybase interfaces file.
Under the Advanced tab, check the Application Using Threads box and check the Enable Quoted Identifiers box.
Under the Connection tab:
Set the charset field to match your Sybase IQ character set.
Set the language field to your preferred language for error messages.
Under the Performance tab:
Set Prepare Method to “2-Full.”
Set Fetch Array Size as large as possible for best performance. This increases memory requirements since this is the number of rows that must be cached in memory. Sybase recommends using a value of 100.
Set Select Method to “0-Cursor.”
Set Packet Size to as large as possible. Sybase recommends using a value of -1.
Set Connection Cache to 1.
