MobiLink Synchronization Wizard in SQL Anywhere 10 - Creating the data source for the MobiLink synchronization setup
(Page 2 of 8 )
MobiLink uses the ODBC interface for its interaction with databases. A User DSN called Dev10 will be used in the synchronization. The following steps show how you may create an ODBC User DSN.
The ODBC DSN can be created both from inside Sybase Central, or externally using the Windows operating system's ODBC DataSource Administrator which can be accessed from Start -->Control Panel-->Administrative Tools and clicking on the Administrative Options. This opens the ODBC Data Source Administrator window shown in the next picture.
Click on the Add... button which opens up the Create New Data Source window with a list of available drivers from which the SQL Native Client driver is chosen as shown in the next picture. This driver has been suggested as an appropriate driver to use while interfacing with MS SQL 2005 Server. For recommended drivers see Appendix 1 (in the Summary section).
Now click on the Finish button to open up the Microsoft SQL Server DSN Configuration window. You are required to provide a name for this data source (which the image shows as already chosen: Dev10). The name of the MS SQL Server 2005 instance is Mysorian on the computer named Hodentek. You may add a description.
Click on the Next button to open the window shown in the next picture. Here you will be asked to describe how you may want to be authenticated. The default is Integrated Windows authentication. For the database that is accessed, the authentication is SQL Server authentication which requires a LoginID and a Password. This option is chosen and the credentials are entered as shown.
When the Next button is clicked in the above window, the following window, Create a New Data Source to SQL Server opens up as shown. In this window you need to change the default database to the database you want to access. Here you will be choosing the database whose tables are going to be used in the synchronization scheme. You may see all the databases by clicking on the drop- down. The Test10 database will be used in this tutorial as mentioned earlier.
Choose Test10 from the drop-down and click on the Next button. The following window opens where you may choose a number of options, such as language for system messages, strong encryption of data, ODBC related log file, and so forth. Here the defaults are chosen.
Click on the Finish button which opens up the ODBC Microsoft SQL Server Setup window shown in the next picture. This shows a summary of all the actions you have taken to configure the User DSN, Dev10.
This may be tested here to verify the connectivity. Click on the button Test Data Source... which opens up the following window, SQL Server ODBC Data Source Test showing that the connection is properly configured for the chosen driver.
When you click OK to this screen you will get back to the previous screen. Click on the OK button one more time and you will get to the first screen of the ODBC Data Source Manager shown here where the DSN Dev10 is added to the list of User DSNs. Close out of this window.
Next: MobiLink Synchronization Wizard >>
More Database Code Articles
More By Jayaram Krishnaswamy
AT&T devCentral & BlackBerry(r) Webcast Series: BlackBerry and GPS -Build Location Awareness into your BlackBerry Applications, July 10th -1:00PM EST. 
