You need an ODBC data source on the client computer for each database you want to access using ODBC. A data source describes how to connect to data on a network. For example, a data source may include the name of a database, the server where it resides, and the network used to access the server.
On UNIX or Linux, ODBC data sources are held in a file named .odbc.ini. You can edit this file with any text editor to specify data sources. For details, see “Using ODBC data sources on UNIX,” in the Sybase IQ System Administration Guide.
You can also use the cross–platform iqdsn utility to create data sources. See “The Data Source utility” in the Sybase IQ Utility Guide.
You may use files as data sources instead of databases. File data sources are stored as files with the extension.dsn. For information about creating a file data source, see Sybase IQ System Administration Guide.
Start the database.
In the ODBC Data Source Administrator, select your new data source from the list of User Data Sources.
Click Configure.
On the ODBC Configuration dialog box, click Test Connection.
If you cannot access the data source, check that you have filled out the various tabs with correct file and path names.
Testing an ODBC data source