In this lesson, you create an ODBC data source that connects MobiLink to the consolidated database.
Create an ODBC data source.
You should use the iAnywhere driver for Oracle that comes with SQL Anywhere 11. Use the following configuration settings:
ODBC tab fields | Values |
---|---|
Data source name | oracle_cons |
User ID | OE |
Password | sql |
SID | orcl |
Procedure returns results | not selected. |
Array size | 60000 |
This tutorial assumes you performed a basic installation of Oracle Database 10g, which creates a starter database named orcl. The Order Entry (OE) schema is automatically installed on orcl. If you installed the OE schema on another database, use the name of the database as the SID value.
To test the ODBC connection, click Test Connection.
After configuring your ODBC data source, you can use the MobiLink plug-in to connect to the Oracle database and create a synchronization model.
For more information about recommended ODBC drivers for MobiLink, see Recommended ODBC Drivers for MobiLink.
For more information about configuration options for the iAnywhere Solutions Oracle driver, see iAnywhere Solutions Oracle driver.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |