Creating a Data Source from the ODBC Administrator

The ODBC Administrator provides an easy way to create an ODBC Data Source.

Start the ODBC Administrator:

Select Settings > Control Panel > Administrative Tools > Data Sources (ODBC).

or

Sybase IQ 15.4 > ODBC Administrator 32-bit

The ODBC Data Source Administrator appears.
Click Add.

The Create New Data Source wizard appears.
Select the Sybase IQ from the list of drivers and click Finish.
In the ODBC Configuration window, type the Data Source Name.
Now click the Login tab. Type the User ID and Password for your database. For example, use DBA and sql.
Click the Database tab. If the data source is on your local machine, type the Server name, a Start line and Database file, including the path.
If the data source is on a remote system, click the Network tab. Click the box for the appropriate protocol and specify the options beside the box. For example, to connect to a server on system PUSHKIN using TCP/IP protocol and port 1870, you would click TCP/IP and type:
```
host=pushkin:1870
```
You could also use the host network address. For example:
```
host=157.133.66.75:1870
```
Click OK when you have finished defining your data source.

The ODBC Data Source Administrator returns you to the User DSN tab.

Note: When specifying network connections, you need a different systemname:port# combination for each database server. The port number must match the one you started the server with.