iODBC SDK Development iODBC SDK on Unix Making a Test Connection Use the iodbctest sample program to test your Data Source Names (DSNs). The following example shows how this is done.zsh, purple 3:58PM bin/ % ls iodbc-config* iodbcadm-gtk* iodbctest* zsh, purple 3:58PM bin/ % echo $ODBCINI /home/tim/.odbc.ini zsh, purple 3:58PM bin/ % ./iodbctest iODBC Demonstration program This program shows an interactive SQL processor Enter ODBC connect string (? shows list): Progress9.x(solaris) | OpenLink Generic ODBC Driver Progress10.x(solaris) | OpenLink Generic ODBC Driver SQLServer | OpenLink Generic ODBC Driver Enter ODBC connect string (? shows list): DSN=<nop>SQLServer Driver: 04.50.0801 OpenLink Generic ODBC Driver (oplodbc.so) SQL>select count(*) from timtest; count ----------- 100 result set 1 returned 1 rows. Any of the DSN attributes in odbc.ini can be overridden in the command line connect string. Connect strings take this formDSN=dsn_name[;attr=value]* The attributes themselves depend on the database driver called by the DSN. Typically, attributes pass a database username and password, some form of server hostname (`host=' or `server='), and a means to identify a database instance on that server (`database='). A driver may also have custom attributes, such as FetchBufferSize, Port, etc.