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, and may include, for example, database name, server where it resides, and network used to access the server.
The AUTOSTOP parameter is required in file data sources
and odbc.ini files, must always be set to NO.
On Windows XP and 2000, 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.
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.
Click Start | Programs | Sybase | Sybase IQ 15.2 .
Choose the appropriate option:
ODBC Administrator 32-bit
ODBC Administrator 64-bit
On the User DSN tab, click Add, choose Server IQ, then click Finish.
On the ODBC Configuration dialog, type a Data Source Name in the Data Source Name box.
Click the Login tab, and enter the database User ID and Password.
Click the Database tab. If the data source:
On a remote machine, type the server name and database file name. (The database file is used only if the database is not started automatically on server start-up.)
On your local machine, type a start line and database name (without the .db extension).
On a remote system, click the Network tab, and select the appropriate protocol and options.
For example, to use TCP/IP to connect to server on
a host named localhost2k and port 1870, select the
TCP/IP box and enter: host=localhost2k:port=1870.
You can also use the host network address:
host=157.133.66.75:1870
Click OK to return to the ODBC Data Source Administrator.
You cannot connect to a Sybase IQ 15.2 server
using an ODBC Data Source Name created for a 12.5 server, even if
you specify the same server name, port number, and database name.
Use the ODBC Data Source Administrator to remove DSNs created in
12.5 and add new DSNs.
You can 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 the Sybase IQ System Administration Guide.
Click Start | Programs | Sybase | Sybase IQ 15.2 | ODBC Administrator.
Choose the data source you want to test, and click Configure.
Click Test Connection.
Creating an ODBC data source