Instruction manual

ODBC Driver and Installation CentreVu® CMS Open Database Connectivity
Desktop Computer Client Configuration 2-30
6. In the Database: Path field, enter:
/cms/db/inf/cms.
7. Leave the
Database: Options field blank.
8. In the
Database: User ID field, you may optionally enter a valid CMS
user login ID. Entering a CMS user login ID displays a default user
name for each login to the data source.
9. Make sure the following items in the
Others section are not
selected:
1.
Read-only connection - If the check box selected complete
access ODBC to customer-defined database tables (c_*
tables) will be denied.
2.
No login dialog box - If the check box selected no login dialog
box will display when you connect to the
CentreVu CMS
database.
You may select this check box to prevent a login dialog box
from displaying with each database access; however, this is
recommended only if the software through which you are
accessing the database, such as
Crystal Reports , is password-
enabled.
10. In the
Others: Row Buffer Size field, enter a row buffer size of 60.
11. Select the OK button, or select the Cancel button to cancel the
configuration.
At this point, the ODBC driver software is installed on your
computer. For further configuration options, you may continue with
“
Administer ODBC Options” in this section.
Once the driver is configured, the
OpenLink ODBC driver is accessible to
ODBC-enabled applications on your computer. Any queries that you send
to the CMS database from client
Windows applications, such as Microsoft
Access
, will use the ODBC feature to access data and copy it to your
applications.
You will need to format the data within your application. The data
returned from your SQL queries will be formatted in the manner
described in Chapter 3, “Database Tables.”
NOTE:
NOTE: