The default user ID for demo.db and newly created databases is DBA and the default password is sql. The user ID is case-insensitive and the password is case-sensitive. You should change the password before deploying the database.

For more information about default user IDs and passwords, see DBA authority.

A lost or forgotten DBA password cannot be recovered. If you require assistance, contact Technical Support ( http://www.sybase.com/support).

The connection parameters required to connect to a database vary depending on the location of the application relative to the database server. The following connection scenarios assume that there is no communication encryption and there is only one database running on a database server.

In the following examples, you connect to the SQL Anywhere sample database, demo.db using Interactive SQL. This file is installed in the SQL Anywhere samples directory represented as samples-dir in the following example. For information about the default location of samples-dir, see Samples directory.

See Connect to the sample database on Unix.

See Connect to the sample database on Mac OS X.

Databases created with SQL Anywhere 9.0.1 or later include the SYSHISTORY system view. The rows in this view that reflect INIT and UPDATE operations give information about when, and with what version, the database was created and upgraded. See SYSHISTORY system view.

To determine the version without starting the database, see DBCreatedVersion function.

Yes, you can install multiple major versions of SQL Anywhere on the same computer. For example, SQL Anywhere 9.0.2, 10.0.1, and 11.0.1 can all be installed and run independently.

However, you must use caution when starting a SQL Anywhere executable that has the same name in multiple versions (for example, dbisql or dbinit) to ensure that you are starting the correct version of the application. You can either specify the full absolute path using environment variables such as SQLANY12, or ensure the version of SQL Anywhere you want is specified first in your path.

See Using the utilities.

For SQL Anywhere 10 and earlier for Windows using the SQL Anywhere installer   Yes, you can install multiple copies of the same version of SQL Anywhere on the same computer. However, the SQL Anywhere installation program registers some drivers and components in the Windows registry, and there is only one copy of the registry. As a result, the ODBC and OLE DB drivers from the most recent installation are used. Similarly, there is only one set of Start menu shortcuts. They point to the most recently installed copy of SQL Anywhere.

For SQL Anywhere 11 and later for Windows using the SQL Anywhere installer   No, you can only install a single copy of SQL Anywhere 11 on a computer.

For SQL Anywhere 12 and earlier for Linux or Unix using the SQL Anywhere installer   Yes, you can install multiple versions in different locations. However, on Linux, if you choose to install application menu items, each user can only have one set of application menu items. They point to the most recently installed copy of SQL Anywhere.

For deployed embedded database applications   Yes, deployed embedded database applications that include SQL Anywhere can be deployed with other SQL Anywhere installations on the same computer.

On Windows operating systems, the ODBC and OLE DB driver names in the registry should include the name of the application in which they are embedded. For example, the ODBC driver name SQL Anywhere 12 should be renamed application-name SQL Anywhere 12. See Deploying databases and applications and Configuring the ODBC driver.

You should run multiple databases on a single database server because this configuration optimizes the use of computer resources.

Having multiple database servers running on the same computer may result in a competition for resources, and (with dynamic cache resizing) this configuration may result in degraded or unpredictable performance. Degraded or unpredictable performance may be acceptable if you need to stop one database server for maintenance without affecting the others, or if you need to isolate errors to a single database server.

You should verify that you are correctly licensed for the installation option that you choose. For more information, see Running multiple databases on a single database server.

See Understanding unexpected changes in the database size.

See the following:

• Designing a backup and recovery plan
• See the tech note titled What Backup, Recovery, and Disaster Recovery Mean to Your SQL Anywhere Databases ( http://www.sybase.com/detail?id=47877)

See the tech note titled I've Got An Assertion! What Should I do? ( http://www.sybase.com/detail?id=1010805).

To report low priority SQL Anywhere bugs, log in to  http://case-express.sybase.com. Bugs reported using Case-Express are assigned a lower priority than cases opened through Technical Support.

For priority issues, open a support case with Technical Support ( http://www.sybase.com/support).

See the following documents:

• Improving database performance
• Performance improvement tips
• Diagnosing Application Performance Issues with SQL Anywhere ( http://www.sybase.com/detail?id=1060302)
• Capacity Planning with SQL Anywhere ( http://www.sybase.com/detail?id=1056535)

See Upgrading SQL Anywhere.

SQL Anywhere performs best when the database is created with the same major version as the database server. Rebuild the database if you are experiencing performance problems and no longer need to run the database on earlier versions of SQL Anywhere. See Rebuilding databases and Improving database performance.

SQL Anywhere developers strive to ensure that applications continue to work after an upgrade. However, your application may be affected by behavior changes and the removal of previously supported features.

To determine if behavior changes have been made to your version of SQL Anywhere, or if features have been removed or deprecated, see SQL Anywhere 12 - Changes and Upgrading. Select the section relevant to your version of SQL Anywhere.

See the tech note SQL Anywhere Supported Platforms and Engineering Support Status ( http://www.sybase.com/detail?id=1002288).

For descriptions of the different licensing options for SQL Anywhere 10 and later, including examples that show you how to apply your license, see SQL Anywhere Licensing  (http://www.sybase.com/detail?id=1056242).

The size of the database that can be supported by SQL Anywhere is dependent on the memory, CPU, and disk drive capacity of the computer on which SQL Anywhere is installed. See SQL Anywhere size and number limitations.

A number of our customers discuss the implementation of large databases in the newsgroups. See the newsgroup thread ( http://forums.sybase.com/cgi-bin/webnews.cgi?cmd=item-99571&group=sybase.public.sqlanywhere.general).

To migrate to SQL Anywhere, you must import your data into a SQL Anywhere database. See Migrating databases to SQL Anywhere.

There are differences between products, such as different dialects of SQL, so your application may need to be modified.

See Choosing SQL Anywhere for ISV Applications ( http://www.sybase.com/detail?id=1053363).

See To create a graphical plan with detailed and node statistics.

No. The OUTPUT statement can only be executed in Interactive SQL and cannot be used within a stored procedure. Use the UNLOAD statement within your stored procedure to save the result set generated by a SQL statement to a text file. If you use the UNLOAD statement in your stored procedure, information is unloaded from the database server and not from the client computer from which the command was executed. See UNLOAD statement.

See:

• SQL Anywhere documentation:  dcx.sybase.com/dcx_home.html
• SQL Anywhere v10 / v9.0.2 Frequently Asked Questions ( http://www.sybase.com/detail?id=1053692)
• SQL Anywhere 11.0.1 FAQs ( http://www.sybase.com/detail?id=1062382)
• SQL Anywhere Studio/Adaptive Server Anywhere Patches and Upgrades FAQ ( http://www.sybase.com/detail?id=1019567)
• SQL Anywhere Web Edition FAQ ( http://www.sybase.com/detail?id=1057560)
• SQL Anywhere newsgroups ( http://www.sybase.com/detail?id=1002557)
• SQL Anywhere Product Page ( http://www.sybase.com/products/databasemanagement/sqlanywhere)