What's New in SQL Anywhere Studio
Upgrading Version 5 Applications
Review of SQL Anywhere Version 5 architecture
If you are using SQL Anywhere Version 5 as a personal server, with an ODBC client application, you are using the following components on your machine:
A SQL Anywhere Version 5 database.
The SQL Anywhere Version 5 database engine.
The SQL Anywhere Version 5 interface library.
The SQL Anywhere Version 5 ODBC driver.
The ODBC driver manager.
A SQL Anywhere Version 5.0 connection description. This may be an ODBC data source, or a connection string from an application.
The following figure illustrates how these pieces fit together. The client application passes a data source name to the ODBC driver manager. The ODBC driver manager looks up the appropriate driver in ODBCINST.INI. The driver looks up the connection information in ODBC.INI and, via the interface library, connects to the SQL Anywhere Version 5 database engine.
