What's New in SQL Anywhere Studio
Upgrading Version 5 Applications
Upgrading ODBC applications
This section provides step-by-step procedures for different kinds of ODBC applications:
Applications using an embedded database are standalone applications using the personal database server (dbeng50.exe for Version 5, dbeng9.exe for Version 9).
Client/server applications connect across a network to the network database server. In Version 5, these applications use the dbclient.exe executable.
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
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.
Create a Version 9 ODBC data source The changes you make depend on the connection parameters you use in the data source.
If you start the default database server using the DBF parameter, you can use the same connection parameters in your new data source as your old one.
If you store a connection string that uses a Start Line parameter specifying dbeng50.exe, you must replace this with one specifying dbeng9.exe.
For more information on upgrading StartLine parameters, see Start parameters and the compatibility library.
If the database server is started in some other way, such as by a batch file or using a Windows NT service, you must reconfigure this so that the newer version of the database server is started instead.
For information on creating data sources, see Working with ODBC data sources.
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
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.
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.
If you start the default database server using the DBF parameter, you can use the same connection parameters in your new data source as your old one.
If you store a connection string that uses a StartLine connection parameter specifying dbclient.exe, you must replace this with a new one. The new connection description should contain all the dbclient information as a set of parameters. If your application contains a hard-coded connection string, you need to take extra steps at this point.
For more information on upgrading StartLine parameters, see Start parameters and the compatibility library.
For more information about creating connection descriptions that capture the dbclient command information, see Capturing dbclient command information.
If the database server is started in some other way, such as by a batch file or using a Windows NT service, you must reconfigure this so that the newer version of the database server is started instead.
For information on creating Version 9 data sources, see Working with ODBC data sources.
Upgrade the database server This step must be carried out at the server machine.
As with any software upgrade, back up your database before upgrading.
Install Adaptive Server Anywhere on the server machine.
Start the Version 9 database server on the database.
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.