You need an ODBC data source on the client computer for each UNIX or Linux database you wish to access using ODBC. A data source describes how to get 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.
On Windows, the ODBC Administrator adds new data sources for you. Each data source allows you to access a database over a network by means of ODBC.
Start the ODBC Administrator on your Windows client system. On Windows 2000, ODBC Administrator is in the Sybase program group.
To configure a 32-bit ODBC Driver, select Settings > Control Panel > ODBC Data Sources. (This runs odbcad32.exe.)
In the ODBC Data Source Administrator, click Add on the User DSN tab.
In the Create New Data Source dialog box, select the Sybase IQ 12 driver and click Finish.
The Configuration dialog box appears.
Type the Data Source Name in the appropriate text box, Type a Description of the data source in the Description text box if desired. Do not click OK yet.
Click the Login tab. Type the User ID and Password for your database. For the sample database used in this example, use “DBA” and “SQL”.
Click the Database tab. If the data source is on a remote machine, type a server name and database file name (with the .DB suffix) in the appropriate text boxes.
If the data source is on your local machine, type a start line and database name (without the .DB suffix) and skip to Step 8.
If the
data source is on a remote system, click the Network tab. Click
the checkbox for the appropriate protocol and type the options in
the adjacent text box. For example, to connect to server on system fiona-pc using TCP/IP
protocol and port 1870, you would click TCP/IP and type host=fiona-pc:1870
You could also use the host network address. For example,
host=157.133.66.75:1870
When specifying network connections, you need a different systemname:port# combination
for each database server. The port number must match the one you
use when you start the server.
Click OK when you have finished defining your data source.
The ODBC Data Source Administrator returns you to the User DSN tab.
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. (To start the Sample Database, use Start > Programs > Sybase > Adaptive Server IQ 12.6 > Start ASIQ Demo 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 pathnames.
Creating an ODBC data source