Creating an ODBC Data Source from the Command Line

You can create User and System Data Sources using the iqdsn command-line utility. You cannot create File Data Sources with iqdsn. You can also use the ODBC Administrator to create User, System, and File Data Sources.

Open a command prompt.
Enter an iqdsn command, specifying the connection parameters you wish to use. For example, the following command creates a data source for the Sybase IQ demo database. The command must be entered on one line:
```
iqdsn -w "My DSN"
"uid=DBA;pwd=sql;dbf=c:\Program Files\Sybase\IQ-15_4\demo\iqdemo.db"
```
The iqdsn output contains the following line:
```
User Data Source "My DSN" written to registry.
```

The iqdsn utility lists Sybase IQ User Data Sources created on the Windows command line.

For more information on the iqdsn utility, see Utility Guide > iqdsn Database Administration Utility.

To edit a data source, select one from the list in the ODBC administrator window and click Configure.

To access Windows across a network to create an ODBC data source, see the Installation and Configuration Guide.