Chapter 3 Working with Dynamo Web Sites

Copying an Adaptive Server Anywhere database

When you copy a Web site database to a new computer, the ODBC data source name is copied to the new machine as well. To connect to the Web site on the new machine, the connection's ODBC data source name must be known on that machine (this applies to all connections, not just the <default> connection). For example, if you create a Web site on machine 1 with an ODBC data source name of "mysite1", then copy the Web site database to machine 2, the ODBC data source name on machine 2 is still named "mysite1". To connect to the Web site on machine 2, do one of the following:

To ensure that the ODBC data source name being used for the connection is known, open the Connections folder on machine 2, select the "default" connection, open the Properties window, and select an existing ODBC data source name from the drop-down list. This enables you to connect to the Web site on machine 2 with the ODBC data source name that you have specified. Repeat this for the other connections where appropriate.
To connect to the Web site database with the ODBC data source name from machine 1 of "mysite1", create a new ODBC data source name on machine 2 of "mysite1". The "default" connection will then recognize "mysite1" as a known ODBC data source name.