The following procedure creates a CustDB consolidated database for any of the supported RDBMS.
You must have access to the SQL scripts that are used to build the CustDB consolidated database as one of the supported RDBMSs. The SQL scripts are located in %SQLANYSAMP16%\MobiLink\CustDB.
Create a database in your RDBMS.
Add the MobiLink system objects by running one of the following SQL scripts, located in the MobiLink\setup subdirectory of your SQL Anywhere 16 installation:
For an Adaptive Server Enterprise consolidated database, run syncase.sql.
For a MySQL consolidated database, run syncmys.sql.
For an Oracle consolidated database, run syncora.sql.
For a SQL Server consolidated database, run syncmss.sql.
Add sample user tables, stored procedures and MobiLink synchronization scripts to the CustDB database by running one of the following SQL scripts, located in %SQLANYSAMP16%\MobiLink\CustDB:
For an Adaptive Server Enterprise consolidated database, run custase.sql.
For a MySQL consolidated database, run custmys.sql.
For an Oracle consolidated database, run custora.sql.
For a SQL Server consolidated database, run custmss.sql.
Create an ODBC data source called CustDB that references your database on the client computer.
Choose Start » Programs » SQL Anywhere 16 » Administration Tools » ODBC Data Source Administrator (32 or 64 bit).
Select the appropriate driver from the list.
Name the ODBC data source CustDB.
Click the Login tab. Enter the User ID and Password for your database.
Click OK and then click OK again.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|