Using DTS: Import From/Export To a Non-Microsoft Database - Create a File DSN for SQL Anywhere

(Page 3 of 5 )

In this section we shall make a file datasource for the SQL Anywhere database that can be used for moving the tables in and out using DTS.

The Start -> All Programs->Control Panel->Administrative Tools->Data Sources (ODBC) trail will open up the ODBC Data Source Administrator window (this is in windows XP Professional). Clicking the File Data Source tab will open up the window of file data sources. If you can identify a window which you had configured earlier, you may be able to pick up that data source. For creating a new datasource as in this tutorial, click on the Add... button. This will open up the next window shown. The Adaptive Server Anywhere 9.0 driver is first in the list. We will use this driver that came with the SQL Anywhere 9.0 download. Click Next.

In the Create  New Datasource Window type a name for your database; here it is called SqlAny. Click on Next> which will bring you to the summary of actions you have taken so far. This  successfully  creates a File Data Source in the location, C:\Program Files\Common Files\ODBC\Data Sources\SqlAny.dsn.

Clicking on the button Finish will bring up the next screen, where you enter the same credentials you used earlier.

Click on the ODBC tab. You will see the following screen, where you will not be configuring anything. 

Click on the Database tab. You will enter essentially the same information you entered for Sybase Central earlier in this tutorial.

You may click on the Browse...button which opens up the following screen. This is the directory where the asademo.db database was installed initially.

If you highlight asademo.db and click Open, you fill up the Database file: text box. Copy and paste the same to the Start Line: text box. Accept other defaults.  Do not worry about the other two tabs for the present task. Click OK to screen one above. You come back to the ODBC data Source Administrator's screen, but you will see the dsn you created in the listing as shown by the highlighted item. This completes your task to create a file DSN for the SQL Anywhere database.

Next: Export a table from MS SQL to SQL Anywhere >>
 

More MS SQL Server Articles
More By Jayaram Krishnaswamy

Comments On: Using DTS: Import From/Export To a Non-Microsoft Database

· Come read the article and comment! The method is quite generic. You can...    · Hi, You say that DTS can be used independantly of MS SQL Server but how would you...    · Hi skippy:Try this free download of MSDE [Download Microsoft SQL Server 2000...    · How do we cary over the primary keys when porting data from sybase to sql...    · I am just returning from a vacation, and I will try to show it through a demo...   >>> Post your comment now!