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 connection parameters.
For example, the following command creates a data source for the SAP 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-16_0\demo\iqdemo.db"
```
The iqdsn output contains the following line:
```
User Data Source "My DSN" written to registry.
```

The iqdsn utility lists SAP 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.