Migrating an MS Access Database to SQL Anywhere with Migration Wizard - Creating a SQL Anywhere Server in Sybase Central
(Page 3 of 6 )
One could connect to the Sybase Central user interface to connect to this database by invoking the following command with the specified switches: dbeng9 -xs http (port=8082) mysorian.db. The mysorian server will respond to HTTP requests at Port 8082 instead of 80, which is being used by IIS. When created new, the database mysorian.db is empty except for system tables, as shown in Figure 4. Make sure there is no space between http and the open parenthesis (.
Connecting to External Data through an ODBC Connection
We shall create a connection (a system dsn) that assists in the migration of data from an MS Access database. This is a System DSN created using the ODBC Data Source Administrator as shown in Figure 5.
The data comes from the MS Access database Migration2.mdb. Therefore the driver we choose is the Microsoft Access Driver, and the database we connect to is Migration2.mdb as shown Figure 6.
When this is configured as above, the DSN MigToAsa is added to the list of System DSNs in the ODBC Data Source Administrator's panel, as shown Figure 7.
Next: The SQL Anywhere Migration Wizard >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
