In this lesson, you create an ODBC data source that connects MobiLink to the consolidated database.
This lesson assumes you have completed all preceding lessons. See Lesson 1: Designing the schemas.
This lesson assumes you have the roles and privileges listed in the Permissions and privileges section at the start of this tutorial: Tutorial: Using MobiLink with an Oracle Database 10g.
Create an ODBC data source.
You should use the SQL Anywhere 16 - Oracle ODBC driver that comes with SQL Anywhere 16. Use the following configuration settings:
|ODBC tab fields||Values|
|Data Source Name||oracle_cons|
|TNS Service Name||orcl|
|Procedure Returns Results Or Uses VARRAY Parameters||selected|
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.
Click Test Connection to test the ODBC connection.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|