To quickly create an ODBC data source, use the Connect window in the administration tools.
Prerequisites
A database is running on the local computer.
Context and remarks
Many.
Creating an ODBC data source (Sybase Central and Interactive SQL)Open the Connect window. See Opening the Connect window (Sybase Central).
If required, click Change Database Type, and then click SQL Anywhere.
Leave the User ID and Password fields blank.
Storing user IDs, encrypted or unencrypted passwords, and database keys in a data source is not recommended. See Do not include passwords in ODBC data sources.
In the Action dropdown list, click Connect To A Running Database On This Computer to connect to a database that is running on your computer.
Specify a Database File Name.
Click Tools » Save As ODBC Data Source.
In the Enter The Name For This New Data Source field, type a name for the data source.
In the Select The Data Source Type list, specify whether the data source is available for the current user or all users.
(Optional) If you are running the 64-bit version of the administration tools and you also have the 32-bit ODBC driver installed, then you have the option to click Create Both 32 And 64-Bit Data Sources.
If you are creating a system data source, then select this option to create two system data sources: one data source that can be used by 32-bit applications and one data source that can be used by 64-bit applications.
If you are creating a user data source, then select this option to create a single user data source that can be used by both 64-bit and 32-bit applications as long as the matching driver is installed. For example, this user data source can be used by a 32-bit application as long as the 32-bit ODBC driver, dbodbc12.dll, is installed in %SQLANY12%. It can also be used by a 64-bit application as long as the 64-bit ODBC driver, dbodbc12.dll, is installed in %SQLANY12%.
Click Save.
Click Close.
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |