You can save sets of connection parameters in a data source. All SQL Anywhere interfaces, except Sybase Open Client and jConnect, can use data sources.
To connect using a data source (Sybase Central or Interactive SQL)Start Sybase Central or Interactive SQL.
If the Connect window does not appear:
In Sybase Central, choose Connections » Connect With SQL Anywhere 12.
In Interactive SQL, choose SQL » Connect.
Click Change Database Type, and then choose SQL Anywhere.
From the Authentication dropdown list, choose Database.
In the User ID field, type a user name.
In the Password field, type a password for the database.
From the Action dropdown list, choose Connect Using An ODBC Data Source.
Do one of the following:
Click ODBC Data Source Name and enter the DataSourceName (DSN) connection parameter that references a data source in the Windows registry. Click Browse to view a list of data sources.
Click ODBC Data Source File and enter the FileDataSourceName (FILEDSN) connection parameter that references a data source held in a file. Click Browse to view a list of files.
Click Connect.
To connect using a data source with a connection string (Sybase Central or Interactive SQL Start Sybase Central or Interactive SQL.
If the Connect window does not appear:
In Sybase Central, choose Connections » Connect With SQL Anywhere 12.
In Interactive SQL, choose SQL » Connect.
Click Change Database Type, and then choose SQL Anywhere.
From the Authentication dropdown list, choose Database.
In the User ID field, type a user name.
In the Password field, type a password for the database.
From the Action dropdown list, choose Connect With A Connection String.
In the Parameters field, type connection parameters in a semicolon delimited list of parameter=value pairs. For example:
DSN=SQL Anywhere 12 Demo";Server=SampleServer |
Click Connect.
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |