Connecting with SQL Anywhere APIs

To connect to a database, the client application must call one of the following SQL Anywhere API functions:

Interface	Details
ODBC	ODBC support Creating ODBC data sources
OLE DB	Connecting to a database using OLE DB
ADO.NET	Connecting to a database
Embedded SQL	Embedded SQL
Sybase Open Client	Using SQL Anywhere as an Open Server Sybase Open Client support
SQL Anywhere JDBC driver	Connecting from a JDBC client application JDBC support
jConnect JDBC driver	Connecting from a JDBC client application JDBC support

The SQL Anywhere API uses connection information included in the call from the client application to locate and connect to the database server. Information sent by the client application can include information held in a data source, the SQLCONNECT environment variable, or the server address cache. The following figure is a simplified representation of the process.

A client connection to a database, showing the client application, the interface library, and the database server running the database.

Additional information

If you want ...	Consider reading ...
An overview of connecting from Sybase Central, Interactive SQL, or the SQL Anywhere Console utility	Working with the Connect window
Some examples to get started quickly, including Sybase Central and Interactive SQL scenarios	Sample SQL Anywhere database connections
To learn about data sources	Creating ODBC data sources
To learn what connection parameters are available	Connection parameters
To see an in-depth description of how connections are established	Troubleshooting connections
To learn about network-specific connection issues	Client/server communications
To learn about character set issues affecting connections	Connection strings and character sets
To learn about connecting through a firewall	Connecting across a firewall

Discuss this page in DocCommentXchange.