Using Data Access Pages to Access Data on a SQL Anywhere 10 Database - Importing from an ODBC Database
(Page 2 of 4 )
The Import window comes up. By default it opens up the My Documents folder to look for an existing MDB file. Click on the Files of type: drop-down to click on the ODBC Databases() item as shown.
When you click on the Import button in the previous import screen, the following window named Select Data Source shows up with the File Data Source tab in default. Change to Machine Data Source and click on the button New..
This opens the Create New Data Source window, where you will opt for creating a System Data Source by choosing the proper radio button. Read the description of what a System Data Source is at the bottom of this screen. Click on the button Next.
In this window (it's actually another page in the Create New Data Source window) you scroll down and choose the SQL Anywhere 10 driver as shown. Click on the button labeled Next.
This shows the summary of our actions up to this point. Click on the button labeled Finish.
Since you are using the SQL Anywhere 10 driver, the ODBC Configuration for SQL Anywhere 10 shows up with five tabbed pages, with the ODBC tab in default as shown. You choose the data source name. SQL Any10 was chosen for this tutorial. Click on the tab Login.
Here you provide the Login for the database. The UserID is dba and the password is sql.
Now click on the Database tab to open the next window. The name of the server is demo10 and the Database file may be found at the same location where the SQL Anywhere 10 software files were installed. The other tabs may be accepted for their default for this tutorial.
When you click OK to the above screen you will return to the Select Data Source screen where you see the SQLAny10 datasource added to the Machine data sources as shown.
Next: Importing the Customers Table >>
More Database Articles
More By Jayaram Krishnaswamy
