Use the Microsoft ODBC Data Source Administrator to create and edit data sources on Windows-based applications. Use the utility to work with User Data Sources, File Data Sources, and System Data Sources.
Storing user IDs, encrypted or unencrypted passwords, and database keys in a data source is not recommended.
To create an ODBC data source (ODBC Data Source Administrator)Choose Start » Programs » SQL Anywhere 12 » Administration Tools » ODBC Data Source Administrator.
To create an ODBC data source for the current user, click the User DSN tab.
To create a system-wide ODBC data source, click the System DSN tab.
Click Add.
In the Name list, choose SQL Anywhere 12. Click Finish.
Specify the connection parameters for the ODBC data source.
Click OK.
Click OK.
Creating a System ODBC data source on 64-bit Windows64-bit versions of Windows maintain two sets of the System Data Source collection; one for 64-bit applications and one for 32-bit applications. To create a System Data Source that is accessible to both 64-bit and 32-bit applications, you must run a copy of the 32-bit ODBC Data Source Administrator (located in the WINDOWS\SysWOW64 folder). To avoid connection problems, set up your 32-bit System Data Source exactly like your 64-bit System Data Source.
To edit an ODBC data source using the ODBC Data Source AdministratorChoose Start » Programs » SQL Anywhere 12 » Administration Tools » ODBC Data Source Administrator.
Click one of the User DSN or System DSN tabs.
In the Name list, click a data source.
Click Configure.
Edit the connection parameters for the ODBC data source.
Click OK.
Click OK.
See also |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |