In this lesson, you create an ODBC data source that connects MobiLink to the consolidated database.
To connect MobiLink to the consolidated databaseCreate an ODBC data source.
You should use the iAnywhere Solutions 12 - Oracle ODBC driver that comes with SQL Anywhere 12. Use the following configuration settings:
| ODBC tab fields | Values |
|---|---|
| Data source name | oracle_cons |
| User ID | OE |
| Password | sql |
| TNS service name | 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 ServiceName value.
Click Test Connection to test the ODBC connection.
After configuring your ODBC data source, you can use Sybase Central to connect to the Oracle database and create a synchronization model.
Further readingFor more information about recommended ODBC drivers for MobiLink, see ![[external link]](gif/external.gif)
http://www.sybase.com/detail?id=1011880.
For more information about configuration options for the iAnywhere Solutions 12 - Oracle ODBC driver, see iAnywhere Solutions 12 - Oracle ODBC driver.
 |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |