Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » MobiLink - Getting Started » MobiLink tutorials » Tutorial: Using MobiLink with an Oracle Database 10g


Lesson 4: Connecting with MobiLink

This lesson assumes you have completed all preceding lessons. See Lesson 1: Designing the schemas.

In this lesson, you create an ODBC data source that connects MobiLink to the consolidated database.

 Connect MobiLink to the consolidated database
  1. Create 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 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 TNS service name value.

  2. Click Test Connection to test the ODBC connection.

  3. Proceed to Lesson 5: Creating a MobiLink project.

 See also