Many of the examples throughout the documentation use the SQL Anywhere sample database. Connect to this database and explore SQL Anywhere features.
Context and remarks
Start Sybase Central or Interactive SQL, and then open the Connect window.
If the Connect window does not appear:
In Sybase Central, click Connections » Connect With SQL Anywhere 12.
In Interactive SQL, click SQL » Connect.
If you are in Interactive SQL and the database type is not SQL Anywhere, click Change Database Type, and then click SQL Anywhere.
In the Action dropdown list, click Connect With An ODBC Data Source.
Click ODBC Data Source Name, and then type SQL Anywhere 12 Demo in the field below.
You do not need to enter a user ID and a password for this connection because the SQL Anywhere 12 Demo data source already contains this information.
In a production environment, it is recommended that you do not store passwords in an ODBC data source. See Do not include passwords in ODBC data sources.
The database server does not need to be running before connecting since the SQL Anywhere 12 Demo data source contains enough information to automatically start the database server. See SQL Anywhere sample database.
Optional: To get a copy of the connection string that is created with this window, click Tools » Copy Connection String to Clipboard.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|