To connect to a database, the client application must call one of the following SQL Anywhere API functions:
Interface | Details |
---|---|
ODBC | |
OLE DB | Connecting to a database using OLE DB |
ADO.NET | Connecting to a database |
Embedded SQL | SQL Anywhere embedded SQL |
Sybase Open Client | |
iAnywhere JDBC driver | |
jConnect JDBC driver |
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.
If you want ... | Consider reading ... |
---|---|
An overview of connecting from Sybase Central or Interactive SQL (including a description of the drivers involved) | Connecting from Sybase Central, Interactive SQL, or the SQL Anywhere Console utility |
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. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |