Sybase Business Intelligence Solutions - Database Management, Data Warehousing Software, Mobile Enterprise Applications and Messaging
Sybase Brand Color Bar
delete

Search for    in all of Sybase.com
view all search results right arrow
  blank
 
 
 
 
 
 
 
 
 
 

 
 
CLICK TO EXPAND NAVIGATION
CLICK TO EXPAND NAVIGATION
 
 
 
 
Support > Technical Documents > Document Types > Technote > Recommended ODBC Drivers For MobiLink

Recommended ODBC Drivers For MobiLink
 
RSS Feed
 
 
 

The MobiLink server connects to several types of consolidated database, using the ODBC 3.5 standard. For some supported consolidated database types and versions of MobiLink, you should use the Sybase iAnywhere ODBC driver for that type of database. For others we recommend drivers supplied by the database vendors. The Sybase iAnywhere ODBC drivers and the MobiLink server are included in the SQL Anywhere Studio product. When Sybase iAnywhere does not provide an ODBC driver, then you must use one provided by another vendor. ODBC drivers from other vendors may not support some optional ODBC functionality that the MobiLink server requires.

Some ODBC drivers have different behaviors that cannot be detected by querying the driver. For these we test the driver to determine viable workarounds. Once we have identified a set of workarounds that are required for a driver, we update the MobiLink server so that it recognizes the version of the driver. It then will automatically apply the required set of workarounds for that driver.

For some ODBC drivers, we are unable to develop viable workarounds for all issues. In these cases, you still may be able to use the driver if your synchronizations do not require the missing driver functionality.

For ease of testing, and to allow MobiLink to apply workarounds to drivers that it does not recognize, the MobiLink workarounds can be set by the undocumented -hw command-line switch. This switch and its associated workarounds are not documented because indiscriminate use of workarounds could cause data corruption or software errors.

Note that after workaround sets are identified, we can make future versions of MobiLink apply the associated hidden workaround switches automatically. Thus if you chose to use hidden workarounds directly, you may not need them with newer versions of the MobiLink server. Continued use of hidden switches with a newer MobiLink may even cause problems or reduced performance.

Driver testing

We use two types of testing of ODBC drivers with MobiLink.

The first, referred to as MLR, is a comprehensive suite of regression tests that exercise synchronization functionality. If some specific MLR tests fail, the driver may still be suitable as long as your synchronizations do not rely on the functionality that failed. For example, if the only MLR tests that fail are for synchronization of LONG BINARY data, then the driver may still be suitable for you if you are not using MobiLink to synchronize LONG BINARY data.

The second type of testing, referred to as MLB, is high-load testing involving many clients synchronizing simultaneously with a MobiLink server running on a multi-processor computer. We have found that some drivers from other vendors will fail with multiple simultaneous connections or under high load while running on multiple processors.

Recommended Drivers

The following pages list the recommended ODBC drivers for different versions of the MobiLink server.

If you are having problems with an older version of MobiLink, you should consider upgrading to a newer version. Older versions may no longer be actively supported. For more information, see SQL Anywhere Supported Platforms and Engineering Support Status.

Product Version Status
MobiLink 16.0 Active
MobiLink 12.0.1 Active
MobiLink 12.0.0 Limited
MobiLink 11.0.1 Active
MobiLink 11.0.0 Archived
MobiLink 10.0.1 Archived
MobiLink 10.0.0 Archived
MobiLink 9.0.2 Archived
MobiLink 9.0.1 Archived
MobiLink 9.0.0 Archived
MobiLink 8.0.3 Archived
MobiLink 8.0.2 Archived
MobiLink 8.0.1 Archived
MobiLink 8.0.0 Archived
MobiLink 7.0.4 Archived
MobiLink 7.0.3 Archived
MobiLink 7.0.2 Archived

The following table describes the active, limited, and archived status in the above table.

Active
  • most bugs are fixed
  • EBFs (Express Bug Fixes) are issued regularly
Limited
  • only serious bugs are fixed
  • EBFs are issued only for serious bugs
Archived
  • no bugs are fixed
  • no EBFs are issued

 

DOCUMENT ATTRIBUTES
Last Revised: Apr 24, 2013
Product: SQL Anywhere
Technical Topics: MobiLink, Compatibility, Database Admin, Install/Upgrade, Troubleshooting, Replication/Synchronization
  
Business or Technical: Technical
Content Id: 1011880
Infotype: Technote
 
 
 

 
© Copyright 2014, Sybase Inc. - v 7.6 Home / Contact Us / Help / Jobs / Legal / Privacy / Code of Ethics