SQL Anywhere API connection

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

Interface	Details
ODBC	ODBC support ODBC data sources
OLE DB	OLE DB and ADO development
ADO.NET	.NET database connection examples
Embedded SQL	Embedded SQL
Sybase Open Client	SQL Anywhere as an Open Server Sybase Open Client support
SQL Anywhere JDBC driver	Connections from a JDBC client application JDBC support
jConnect JDBC driver	Connections 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 an ODBC data source, the SQLCONNECT environment variable, or the database server address cache (sasrv.ini). 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	Opening the Connect window (Sybase Central)
Some examples to get started quickly, including Sybase Central and Interactive SQL scenarios	Connection IDs
To learn about data sources	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	Communication protocols
To learn about character set issues affecting connections	Connection strings and character sets
To learn about connecting through a firewall	Firewall connections

SQL Anywhere API connection

Additional information

See also