SQL Anywhere Connection Help

RazorSQL ships with the JDBC drivers necessary to connect to Sybase SQL Anywhere databases. There is also an ODBC driver available for SQL Anywhere, and if using Windows, users can connect to SQL Anywhere with RazorSQL using ODBC assuming an ODBC datasource has been configured for SQL Anywhere in the ODBC control panel. However, it is recommended that users use the SQL Anywhere JDBC driver that ships with RazorSQL.

Connecting to SQL Anywhere via JDBC

To connect to a SQL Anywhere database, select the JDBC (JConnect for SQL Anywhere) connection type from the connection type list. Enter any login information if applicable, and then enter the host or ip address of the SQL Anywhere server, and the port SQL Anywhere is listening on (the default is 2638). Next, enter the name of the SQL Anywhere database to connect to.

Connecting to SQL Anywhere via ODBC

To connect to SQL Anywhere via ODBC, the SQL Anywhere ODBC driver must be downloaded and installed. Next, an ODBC data source must be set up via the Windows data sources control panel. See the following link for more information:

ODBC Setup

Manual SQL Anywhere JDBC Information

If manually configuring your connection, see the following for JDBC driver class and JDBC URL format. JDBC Information