Open Database Connectivity (ODBC) is a standard interface for connecting client applications to database management systems in a Windows environment. Connections are made by specifying connection parameters stored in an ODBC data source. This section tells you how to create an ODBC Data Source Name (DSN) to connect to the sample database.
Sybase recommends creating System DSNs
You need a System DSN because it is visible to all users on
the machine, while a User DSN is only visible to that user. If you
create System DSNs, you can share them with all users on the network.
Users will not need to create the data sources on their own machines.
Creating an ODBC DSN for Sybase IQ 12.6
Click Start, point to Settings | Control Panel.
Click Administrative Tools, choose Data Sources (ODBC).
On the ODBC Data Source Administrator, click the System DSN tab, click Add, choose Adaptive Server IQ, click Finish.
On the ODBC Configuration dialog, click the ODBC tab, type a connection name in the Data source name box.
Click the Login tab, and in the User ID and Password boxes, type the user ID and password you want to use to connect to the database.
The default user ID is DBA, and default password SQL. The DBA user ID automatically has DBA authority within the database. This permission level grants a user the right to carry out any activity in the database.
Click the Database tab. In the Server name box, type the Sybase IQ server name. In the Database name box, type the name of the IQ database.
In the Database file box, type the full path and name of the IQ database. You can also click the Browse button to locate the file.
Click OK to create the data source and OK to close the dialog box.
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
