To create an ODBC data source, you can use the ODBC Data Source Administrator.
Context and remarks
Creating a system ODBC data source on 64-bit Windows 64-bit versions of Windows maintain two sets of system data sources: one for 64-bit applications and one for 32-bit applications. To create a system data source that is accessible to 32-bit applications, you must run the 32-bit ODBC Data Source Administrator (located in the WINDOWS\System32 folder). To avoid connection problems, set up your 32-bit system data source exactly like your 64-bit system data source.
Creating a user ODBC data source on 64-bit Windows 64-bit versions of Windows maintain one set of user data sources. You can use either the 32-bit or the 64-bit version of the ODBC Data Source Administrator to create a user data source. This data source can be used both by 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 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 data source, click the System DSN tab.
In the Name list, choose SQL Anywhere 12. Click Finish.
Specify the connection parameters for the ODBC data source.
Storing user IDs, encrypted or unencrypted passwords, and database keys in a data source is not recommended.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|