SAP / Sybase ASE unable to display tables in Database Explorer

This topic describes the following errors with SAP ASE when you start the Database Explorer:

HY000(0)[MERANT][ODBC Sybase ASE driver]PrepareMethod must be 0 or 1 for SQLDescribeParam support

or

HY000(12828)[DataDirect][ODBC Sybase Wire Protocol driver][SQL Server]The datatype of a parameter marker used in the dynamic prepare statement could not be resolved

This problem can be resolving by changing a setting on the configuration of your SAP ASE ODBC Datasource. This is done as follows:

from the AQT signon window, click on Datasources > Manage Datasources.
click on your SAP ASE datasource then click on Configure.
You need to change the Prepare Method parameter, which is on the Performance tab. If you got the first of the two messages above, you need to change the Prepare Method to 0 or 1. If you got the second of the two messages, you need to change the Prepare Method to 2 - Full.

Another Solution

This error arises because AQT uses parameterised queries, which SAP ASE occassionally has trouble with. If you are still having problems, you can switch off the use of parameterised queries by, in AQT, going Options > Table Information, set Parameter Usage to Use Substitution.

Advanced Query Tool

https://www.querytool.com