ASA Database Administration Guide
Connecting to a Database
Working with ODBC data sources
You can create ODBC data sources on Windows 95/98/Me and Windows NT/2000/XP operating systems using the ODBC Administrator, which provides a central place for creating and managing ODBC data sources.
Adaptive Server Anywhere also includes a cross-platform utility named dbdsn to create data sources.
This section describes how to create an ODBC data source. Before you create a data source, you need to know which connection parameters you want to include in it.
For more information, see Simple connection examples, and Connection parameters.
On Windows 95/98/Me and Windows NT/2000/XP, you can use the Microsoft ODBC Administrator to create and edit data sources. You can work with User Data Sources, File Data Sources, and System Data Sources in this utility.
To create an ODBC data source (ODBC Administrator)
Start the ODBC Administrator:
In Sybase Central, choose Tools
or From the Windows Start menu, choose Programs
The ODBC Data Source Administrator dialog appears.
Click Add.
The Create New Data Source wizard appears.
From the list of drivers, choose Adaptive Server Anywhere 9.0, and click Finish.
The ODBC Configuration for Adaptive Server Anywhere dialog appears.
Most of the fields in this window are optional. Click the question mark at the top right of the window and click a dialog field to find more information about that field.
For more information about the fields in the dialog, see Configuring ODBC data sources using the ODBC Administrator.
When you have specified the parameters you need, click OK to close the window and create the data source.
To edit a data source, find and select one in the ODBC Administrator main window and click Configure.
You can create User Data Sources using the dbdsn utility. You cannot create File Data Sources or System Data Sources. File and System Data Sources are limited to Windows operating systems only, and you can use the ODBC Administrator to create them.
To create an ODBC data source (Command line)
Open a command prompt.
Type a dbdsn command, specifying the connection parameters you wish to use.
For example, the following command creates a data source for the Adaptive Server Anywhere sample database. The command must be typed on one line:
dbdsn -w "My DSN" "uid=DBA;pwd=SQL;dbf=c:\Program Files\Sybase\SQL Anywhere 9\asademo.db"
For more information on the dbdsn utility, see The Data Source utility.