You can save sets of connection parameters in a data source. ODBC and JDBC using the iAnywhere JDBC driver use data sources, as do Embedded SQL applications like DBISQLC. You can create data sources from the ODBC Administrator. See “Creating and editing ODBC data sources” for details.
All applications can benefit from using data sources. For more information, see “Specifying a driver for your connection”.
Connecting from Sybase Central or Interactive
SQL using a data source
Start Sybase Central or Interactive SQL and open the Connect dialog (if it doesn’t appear automatically).
On the Identification tab (Login tab in Interactive
SQL Classic), enter a user ID and password, for example, DBA and sql.
On the lower half of the Identification tab, do one of the following:
Select the ODBC Data Source Name option and specify a data source name (equivalent to the DSN connection parameter, which references a data source in the registry). To view a list of data sources, click Browse.
Select the ODBC Data Source File option and specify a data source file (equivalent to the FileDSN connection parameter, which references the data source held in a file.). You can search for a file by clicking Browse.
The Sybase IQ Demo data source holds a set of connection parameters, including the database file and a Start parameter to start the database.
You can also specify the data source name by including
the dsn connection parameter in the dbisql command,
as follows:
dbisql -c "dsn=Sybase IQ Demo"
The iqdemo data source holds a set of connection parameters, including the database file and a Start parameter to start the sample database. The server name in this data source is “hostname_iqdemo” where hostname represents your system name.
