Driver

SQL Anywhere 11.0

Version

11.0.1

Status

Recommended for use with MobiLink.

Client s/w

None.

OS

Windows

200x, XP, Vista

Linux

Redhat Enterprise Linux 4, 5
SuSE 10, SuSE Enterprise Linux 9, 10
Supported where the kernel/glibc versions are within the ranges specified on the SQL Anywhere Supported Linux Platforms .

Solaris

8, 9, 10

AIX

5.3, 6.1, 7.1^{[build 11.0.1.2637 and up]}

MAC OS X

10.5 (Intel)

Pros

All tests pass.

Cons

None.

Notes

None

Driver

Sybase Adaptive Server Enterprise ODBC driver

Version

15.0.0.335 (Win32 and 64) and 15.0.0.335 (Linux32 and 64). These drivers are available from the ASE 15.0 SDK ESD#16.

Status

Recommended for use with MobiLink with caveats.

Client s/w

None

OS

Windows

200x, XP, Vista

Linux

Redhat Enterprise Linux 4, 5
SuSE 10

Pros

All tests pass

Cons

1. On Linux, if set UseCursor=1, the synchronization tables can't be dropped after synchronization.
2. Due to a bug in the 32- and 64-bit ASE native ODBC drivers we have tested, the MLSD feature in the MobiLink server currently may not work for ASE.

Notes

1. Always set UseCursor to zero on Linux.
2. Always set ServerInitiatedTransactions to zero.
3. Set AnsiNull to 1, if the "where clauses" of any of the upload and download scripts may have the clause of "column_name = NULL".
4. On Linux, you need to set SYBASE environment variable to the directory where you install ASE SDK1500, otherwise, you will get the error, "Could not load code page for requested charset".
5. On Linux, the 64-bit MobiLink server and the other ODBC drivers define SQLLEN (an ODBC data type) as a 64-bit integer, but the Sybase ASE ODBC driver defines SQLLEN as a 32-bit integer. This disagreement will be handled by the iAnywhere ODBC driver manager for UNIX, if a DSN for ASE on UNIX contains the following entry
     length32=1
   This is required by the 64-bit MobiLink server on UNIX for ASE.

Driver

iAnywhere Solutions 11 - Oracle ODBC Driver

Version

11.00.01

Status

Recommended for use with MobiLink.

Client s/w

Oracle 10g client

OS

Windows

200x, XP, Vista

Linux

Redhat Enterprise Linux 4, 5
SuSE 10, SuSE Enterprise Linux 10

Solaris

8, 9, 10

AIX

5.3, 6.1, 7.1^{[build 11.0.1.2637 and up]}

Pros

All tests pass.

Cons

Notes

1. Before using this driver, you must install Oracle 10g client. To load this driver, you must set Oracle client libraries in your LD_LIBRARY_PATH (Linux, Solaris) or LIBPATH (AIX).
2. SID on Windows DSN setting and in Linux and Unix .odbc.ini are Oracle TNS service name defined in $ORACLE_HOME/network/admin/tnsnames.ora
3. The default setting of "Procedure return results" on Windows or ProcResults on Linux and Unix is no.
4. If you are using a stored procedure that returns a REF CURSOR, the REF CURSOR parameter (either OUT or IN OUT) must be defined as the last parameter in the parameter list of the stored procedure.

Driver

iAnywhere Solutions 11 - Oracle ODBC Driver

Version

11.00.01

Status

Recommended for use with MobiLink.

Client s/w

Oracle 11g client

OS

Windows

200x, XP, Vista

Linux

Redhat Enterprise Linux 4, 5
SuSE 10, SuSE Enterprise Linux 10

Solaris

9, 10

AIX

5.3, 6.1, 7.1^{[build 11.0.1.2637 and up]}

Pros

All tests pass.

Cons

Notes

1. Before using this driver, you must install Oracle 11g client. To load this driver, you must set Oracle client libraries in your LD_LIBRARY_PATH (Linux, Solaris) or LIBPATH (AIX).
2. SID on Windows DSN setting and in Linux and Unix .odbc.ini are Oracle TNS service name defined in $ORACLE_HOME/network/admin/tnsnames.ora
3. The default setting of "Procedure return results" on Windows or ProcResults on Linux and Unix is no.
4. If you are using a stored procedure that returns a REF CURSOR, the REF CURSOR parameter (either OUT or IN OUT) must be defined as the last parameter in the parameter list of the stored procedure.

Driver

Microsoft SQL Native Client ODBC Driver

Version

2005.90.xxxx.00

Status

Recommended for use with MobiLink.

Client s/w

None

OS

200x, XP, Vista

Pros

Passes all tests.

Cons

None

Notes

Be sure to put "SET NOCOUNT ON" at the start of all stored procedures and batches that are executed via ODBC.

Driver

Microsoft SQL Native Client ODBC Driver

Version

2007.100.xxxx.xx

Status

Recommended for use with MobiLink.

Client s/w

None

OS

200x, XP, Vista

Pros

Passes all tests.

Cons

None

Notes

Be sure to put "SET NOCOUNT ON" at the start of all stored procedures and batches that are executed via ODBC.

Driver

IBM DB2 ODBC Driver

Version

8.01.17.644 (Win32 and 64), 8.02.0009 (Linux32 and 64). These drivers can be retrieved from DB2 FixPack 17.

Status

Recommended for use with MobiLink.

Client s/w

DB2 UDB Client 8.2

OS

Windows

200x, XP, Vista

Linux

Redhat Enterprise Linux 4, 5
SuSE Enterprise Linux 9, 10

Solaris

8, 9, 10

AIX

5.3, 6.1, 7.1^{[build 11.0.1.2637 and up]}

Pros

All tests pass.

Cons

None

Notes

For OS support, please refer to http://www-306.ibm.com/software/data/db2/9/sysreqs.html ( This link may be changed in the future by IBM).

On Solaris, the IBM DB2 ODBC drivers may require certain levels of OS patches, please check the IBM Web site for more details.

On Linux, Solaris and AIX, you need to source db2profile to export DB2 environment variables. db2profile is in your DB2 install home directory.

Two database configuration parameters LOCKLIST and APPLHEAPSZ need to be changed for high load testing. Set LOCKLIST to 500 and APPLHEAPSZ to 1024.

On Linux, Solaris and AIX, the 64-bit MobiLink server and the other ODBC drivers define SQLLEN (an ODBC data type) as a 64-bit integer, but the DB2 ODBC driver, version 8.02.0009 for UNIX defines SQLLEN as a 32-bit integer. This disagreement will be handled by the iAnywhere ODBC driver manager for UNIX, if a DSN for DB2 on UNIX contains the following entry
  length32=1
This is required by the 64-bit MobiLink server on UNIX for DB2 with DB2 ODBC driver, version 8.02.0009.

QAnywhere does not support consolidated databases running on a DB2 mainframe.

Driver

IBM DB2 ODBC Driver

Version

9.05.201.346 (Win32 and 64), 9.05.0002 (Linux32 and 64). These drivers can be retrieved from DB2 FixPack 2a.

Status

Recommended for use with MobiLink.

Client s/w

DB2 UDB Client 9.5

OS

Windows

200x, XP, Vista

Linux

Redhat Enterprise Linux 4, 5
SuSE Enterprise Linux 9, 10

Solaris

9, 10

Pros

All tests pass.

Cons

None

Notes

For OS support, please refer to http://www-306.ibm.com/software/data/db2/9/sysreqs.html ( This link may be changed in the future by IBM).

On Solaris, the IBM DB2 ODBC drivers may require certain levels of OS patches, please check the IBM Web site for more details.

On Linux, Solaris and AIX, you need to source db2profile to export DB2 environment variables. db2profile is in your DB2 install home directory.

Two database configuration parameters LOCKLIST and APPLHEAPSZ need to be changed for high load testing. Set LOCKLIST to 500 and APPLHEAPSZ to 1024.

QAnywhere does not support consolidated databases running on a DB2 mainframe.

Driver

MySQL ODBC driver

Version

5.01.05 (Win32 and 64) and 5.01.05 (Linux32 and 64).

Status

Recommended for use with MobiLink Server

Client s/w

None

OS

Windows

200x, XP, Vista

Linux

Redhat Enterprise Linux 4, 5
SuSE 10, SuSE Enterprise Linux 9, 10

Pros

All tests pass

Cons

None

Notes

1) Storage Engine:

MySQL offers a set of storage engines in a MySQL server and some storage engines are ACID compliant and some are not. The MobiLink server requires an ACID compliant storage engine, such as InnoDB, Falcon. Please make sure the default storage engine is ACID compliant. If the default storage engine is not ACID compliant, please make sure all the MobiLink server system tables are created using an ACID compliant storage engine.

2) Stored Procedures:

The MySQL ODBC driver does not support inout or out parameters for stored procedure calls. Therefore, all procedures that need inout parameters must be written as functions that can return an out value.

The MobiLink server events that require inout parameters, such as authenticate_user, handle_error, modify_user must be implemented as functions and run using a select statement, like
  select function_name( ?, ?, ?, ... )
and not { call function_name( ?, ?, ?, ... ) }. Then the MobiLink server will catch the return value properly.

If the MobiLink server scripts use named parameters, the parameters will not be changed after execution of the script. User-defined named parameters, e.g. {ml u.my_var} are thus not supported.

3) Cursor Scripts:

The upload_fetch, download_cursor, or download_delete_cursor event may be written as a select statement and the MobiLink server uses the read-committed isolation level to execute the select statement. However, with the read-committed isolation, the MySQL ODBC driver may allow the MobiLink server to read uncommitted operations (inserts, updates and deletes). Then with this behavior, synchronization data would not be consistent between the consolidated and remote databases. This problem has been reported to MySQL.

To work around this problem, all the select statements for the upload_fetch, download_cursor, and download_delete_cursor events must contain a "lock in share mode" clause. For instance, a download_cursor script should be written as
select col1, col2, ..., coln from a_sync_table where last_modified > ? ... lock in share mode
if it is a select statement. With the "lock in share mode" clause, the select statement will be blocked by any uncommitted operations made by the other connections on the same table and then upload updates and download data will be consistent in the consolidated and remote databases.

4) UNIX Platforms:

There are two ways to specify an ODBC configuration file on UNIX:

a) Place the file ODBC.INI (the file name must be in upper case) or symbolic link, ODBC.INI in the home directory of the current user;
b) Create an environment variable, ODBCINI and setup this environment variable by pointing it to the real ODBC configuration file.

On UNIX platforms, the 64-bit MobiLink server and the other ODBC drivers define SQLLEN (an ODBC data type) as a 64-bit integer, but the MySQL ODBC driver defines SQLLEN as a 32-bit integer. This disagreement will be handled by the iAnywhere ODBC driver manager for UNIX, if a DSN for MySQL on UNIX contains the following entry
  length32=1
This is required by the 64-bit MobiLink server on UNIX for MySQL.

A sample DSN for MySQL on UNIX can be
  [a_mysql_dsn]
  Driver=full_path/libmyodbc5.so
  server=host_name
  uid=user_name
  pwd=user_password
  database=database_name
  length32=1

5) QAnywhere Support:

QAnywhere does not support consolidated databases running on MySQL servers.