Contents Index Upgrading ODBC applications Upgrade notes for PowerBuilder and InfoMaker users

What's New in SQL Anywhere Studio
  Upgrading Version 5 Applications
    Upgrading ODBC applications

Upgrade procedures for ODBC applications


This section provides step-by-step procedures for different kinds of ODBC applications:

Some applications allow you to change the ODBC data source name you use. Other applications use a fixed data source name. You can upgrade either kind of application.

To upgrade ODBC applications that use an embedded database

  1. Install the current software    The current version of the software contains components that enable Version 5 ODBC applications to continue working. You can either install into a separate directory or over the top of your Version 5 software.

    Your application should be unaffected by installation of the current version of the software.

  2. Create a Version 9 ODBC data source    The changes you make depend on the connection parameters you use in the data source.

  3. Use the new data source    With this step, you are using all current software and have completed your upgrade. The database itself does not need to be upgraded to work with existing applications.

Some applications may have the data source name hard wired. In this case, you need to replace the Version 5 data source with a Version 9 data source of the same name. It is recommended that you rename, rather than delete, your Version 5 data source.

To upgrade ODBC client/server applications

  1. Prepare for the upgrade    This step must be carried out at each client machine. You prepare for the upgrade by installing the current version of the software.

    Your application should be unaffected by installation of the current version of the software.

  2. Create a Version 9 ODBC data source    This step must be carried out at each client machine. The changes you make depend on the connection parameters you use in the data source.

  3. Upgrade the database server    This step must be carried out at the server machine.

  4. Use the new data source    This step must be carried out at each client machine. You need to use the new connection description to connect to the newer version of the database server. With this step, you are using all current software and have completed your upgrade. The database itself does not need to be upgraded to work with existing applications.


Contents Index Upgrading ODBC applications Upgrade notes for PowerBuilder and InfoMaker users