The following tables list components that are available across each platform supported by SQL Anywhere. Note that, with a few exceptions, components that are available in all supported platforms are not listed. For ease of reading, the platforms are grouped by operating system vendor, operating system name and processor architecture.
Information about support for a specific operating system version is located at SQL Anywhere Supported Platforms and Engineering Support Status.
Note: when printing this document, a landscape page format yields the best result.
The following tables are available:
- Databases
- Synchronization and Messaging
Databases
SQL Anywhere
|
Components |
Microsoft | Sun | Apple | IBM | HP | |||||
| Windows | Linux | Solaris | Mac OS X | AIX31 | HP-UX | |||||
| x86 | x64 | Mobile | x86 | x64 | SPARC | x64 | x86 | PPC | IA64 | |
| Personal database server | X | X | X | X | X27 | X | X | X19 | X26 | |
| Network database server | X | X | X | X | X | X27 | X | X | X19 | X26 |
| Remote data access | X | X | X | X | X | X | ||||
| External stored procedures | X | X2 | X | X | X | X | X | X | X | |
| Dynamic cache sizing | X | X | X | X | X | X | X | X | X | X |
| C++ development tools | X | X | X | X | X | X | X | X | ||
| 5.0 Compatibility DLLs | X | |||||||||
| International Resource Deployment Kit | X | X | ||||||||
| Accessibility enablement | X | |||||||||
| Samples | X | X | X | X | X | X | X | X | X | X |
| Sun JRE 1.6.0 | X | X | X | X | ||||||
| RSA Encrypted Client-Server Communications | X | X | X | X | X | X | X | X | X | X |
| Java in the database | X | X | X | X | X | X | X | X | X | |
| Kerberos clients32 | X |
X |
X |
X |
X |
X |
X |
|||
| Components | Microsoft | Sun | Apple | IBM | HP | |||||
| Windows | Linux | Solaris | Mac OS X | AIX31 | HP-UX | |||||
| x86 | x64 | Mobile | x86 | x64 | SPARC | x64 | x86 | PPC | IA64 | |
| Interfaces | ||||||||||
| ODBC 3 | X | X | X | X | X23 | X23 | X23 | X | X23 | X23 |
| OLE DB | X | X | X | |||||||
| ADO.NET | X | X | X | |||||||
| Embedded SQL | X | X | X | X | X23 | X23 | X23 | X | X23 | X23 |
| Open Client | X | X | X | X23 | X | X23 | ||||
| iAnywhere JDBC 5 | X | X | X | X23 | X23 | X | X | X23 | X23 | |
| jConnect | X | X | X | X23 | X23 | X | X | X23 | X23 | |
| PHP | X | X | ||||||||
| Perl DBD | X | X | X | X | X | X | X | X | X | |
| Database tools | X | X | X | X | X23 | X23 | X23 | X | X23 | X23 |
| Database utilities | ||||||||||
| Histogram (dbhist) | X | X | ||||||||
| Language (dblang) | X | X | ||||||||
| Service creation (dbsvc) | X | X | X | X | ||||||
| All other utilities | X | X | X | X | X | X | X | X | X | |
| Components | Microsoft | Sun | Apple | IBM | HP | |||||
| Windows | Linux | Solaris | Mac OS X | AIX31 | HP-UX | |||||
| x86 | x64 | Mobile | x86 | x64 | SPARC | x64 | x86 | PPC | IA64 | |
| Separately licensed components | ||||||||||
| ECC Encrypted Client-Server and MobiLink Communications | X | X | X | X | X | X | X | X | ||
| FIPS Approved Encrypted Client-Server and MobiLink Communications | X | |||||||||
| High availability | X | X | X | X | X | X | X | X | X | |
UltraLite
| Components | Microsoft | |||||
| Windows | ||||||
| XP | Mobile | Palm OS | BlackBerry | Java ME/SE | Linux x86 24 | |
| UltraLite databases | X | X | X | X | X | X |
| UltraLite engine | X | X | X | |||
| API | ||||||
| UL embedded SQL 11 | X | X | X | X | ||
| UL C++ component 9 | X | X | X | X | ||
| UL for M-Business Anywhere 11 | X | X12 | X13 | |||
| UltraLite.NET | X9 | X10 | ||||
| UltraLiteJ | X | X33 | X | |||
| Synchronization | ||||||
| TCP/IP | X | X | X | X | ||
| HTTP or HTTPS | X | X | X | X | X | X |
| ActiveSync 8 | X14 | |||||
| HotSync | X | |||||
| RSA Encrypted MobiLink Communications | X | X16 | X | X | ||
| Separately licensed components 15 | ||||||
| ECC Encrypted MobiLink Communications | X | X16 | X | X | ||
| FIPS Approved Encrypted MobiLink Communications | X | |||||
Synchronization and Messaging
MobiLink
| Components | Microsoft | Sun | Apple | IBM | HP | |||||
| Windows | Linux | Solaris | Mac OS X | AIX31 | HP-UX | |||||
| x86 | x64 | Mobile | x86 | x64 | SPARC | x64 | x86 | PPC | IA64 | |
| MobiLink Server | ||||||||||
| MobiLink synchronization server | X | X | X | X | X27,34 | X19 | ||||
| .NET synchronization logic | X | X | ||||||||
| Java synchronization logic | X | X | X | X | X | |
X18 | |||
| Notifier 28 | X | X | X | X | X | |
X18 | |||
| RSA Encrypted MobiLink Communications | X | X | X | X | X | |
X | |||
| Samples | X | X4 | X | X | X | |
||||
| Relay Server | X1 | X1 | X20 | |||||||
| MobiLink Monitor | ||||||||||
| MobiLink monitor | X | X4 | X | X4 | X | |||||
| MobiLink Client | ||||||||||
| MobiLink client for SQL Anywhere | X | X4 | X | X | X4 | X4 | X |
|||
| Listener 29 | X | X4 | X | |||||||
| MobiLink ActiveSync provider 22 | X | |||||||||
| RSA Encrypted MobiLink Communications |
X |
X | X |
X |
X |
X |
||||
| Separately licensed components | ||||||||||
| ECC Encrypted MobiLink Communications | X | X | X | X | X4 | X | X | |||
| FIPS Approved Encrypted MobiLink Communications | X | X | ||||||||
For a list of platforms that can run the Redirector and a list operating systems that it was tested on, please refer to this document.
The MobiLink server communicates with the consolidated databases through an ODBC driver. The ODBC driver may not be available for some consolidated databases on some platforms. The consolidated database and MobiLink server are not required to run on the same platform. Provided the consolidated database is running on a supported platform as specified by the database vendor, and the MobiLink server is communicating with the consolidated database using a supported ODBC driver, this is considered a supported MobiLink server configuration. The following table lists the platforms that can run the MobiLink server for supported consolidated databases. For more details about the ODBC drivers, please refer to the document Recommended ODBC Drivers for MobiLink.
| Consolidated databases | Microsoft | Sun | Apple | IBM | HP | |||||
| Windows | Linux | Solaris | Mac OS X | AIX31 | HP-UX | |||||
| x86 | x64 | Mobile | x86 | x64 | SPARC | x64 | x86 | PPC | IA64 | |
|
SQL Anywhere (11) |
X | X | X | X | X |
|
X |
|||
|
Adaptive Server Enterprise (12.5, 15.0.2) |
X | X | X | X | ||||||
|
Oracle (10g, 11g) |
X | X | X | X | X |
|
X |
|||
|
Microsoft SQL Server 2005 |
X | X | ||||||||
|
IBM DB2 UDB LUW (8.2, 9.5) |
X | X21 | X | X | X |
|
X |
|||
| IBM DB2 Mainframe z/OS 8.1 |
X | |||||||||
| MySQL (5.1) |
X | X | X | X | ||||||
QAnywhere
| Components | Microsoft | Sun | Apple | IBM | HP | |||||
| Windows | Linux | Solaris | Mac OS X | AIX31 | HP-UX | |||||
| x86 | x64 | Mobile | x86 | x64 | SPARC | x64 | x86 | PPC | IA64 | |
| MobiLink synchronization server with Messaging enabled | X | X | X | X4 | X27 | X | X18, 19 | |||
| Agent | X | X | ||||||||
| .NET API | X | X | ||||||||
| C++ API | X | X | ||||||||
| Java API | X | X25 | ||||||||
| Samples (client) | X | X | ||||||||
SQL Remote for SQL Anywhere
| Components | Microsoft | Sun | Apple | IBM | HP | |||||
| Windows | Linux | Solaris | Mac OS X | AIX31 | HP-UX | |||||
| x86 | x64 | Mobile | x86 | x64 | SPARC | x64 | x86 | PPC | IA64 | |
| SQL Anywhere Message Agent (dbremote) | X | X | X | X | X | |||||
| SQL Anywhere extraction utility (dbxtract) | X | X | X | X | ||||||
| File sharing message system | X | X | X | X | X | |||||
| FTP message system 17 | X | X | X | X | X | |||||
| SMTP/POP message system 17 | X | X | X | X | X | |||||
| SA encoding (dbencod) | X | X | X | X | ||||||
Replication Agent for SQL Anywhere
| Components | Microsoft | Sun | Apple | IBM | HP | |||||
| Windows | Linux | Solaris | Mac OS X | AIX31 | HP-UX | |||||
| x86 | x64 | Mobile | x86 | x64 | SPARC | x64 | x86 | PPC | IA64 | |
| Replication Agent (dbltm) | X | X | X4 | |||||||
Administration Tools
| Components | Microsoft | Sun | Apple | IBM | HP | |||||
| Windows | Linux | Solaris | Mac OS X | AIX31 | HP-UX | |||||
| x86 | x64 | Mobile | x86 | x64 | SPARC | x64 | x86 | PPC | IA64 | |
| Administration Tools | ||||||||||
| Sybase Central | X | X6 | X | X6 | X | |||||
| Interactive SQL | X | X6 | X | X6 | X | X7 | X7 | X7 | ||
| Network server monitor (dbconsole)30 | X | X6 | X | X6 | X | |||||
| PowerDesigner | X | |||||||||
| InfoMaker | X | |||||||||
| DataWindow .NET | X | |||||||||
Documentation
SQL Anywhere documentation is written in the form of product manuals or books, and is available in a variety of formats.
- At DocCommentXchange, view, comment on, and view other comments on the complete set of books.
- For Windows, the complete set of books is provided in HTMLHelp (CHM) and PDF formats.
- For Unix platforms, the complete set of books is provided in HTML and PDF formats.
- Context-sensitive help for the administration tools is provided in JavaHelp format.
- Some API documentation is also provided in formats specific to application development environments.
Footnotes
1 Requires Microsoft IIS 6. Note that Microsoft IIS 7 (included with Windows 7 and Windows Server 2008) is not supported.
2 The older interface to external stored procedures is available only in 32-bit software.
3 ODBC driver manager may not be available. May have to link directly to ODBC driver.
5 Requires JRE 1.4 or higher on Itanium chips. Requires JRE 1.3 or higher on other chips.
7 Does not include certain features, compared to the admin tools provided on other operating systems.
8 Requires Microsoft ActiveSync 3.1 or higher.
9 64-bit development requires the 32-bit utilities. Connecting to an UltraLite database from a 64-bit machine requires the 32-bit versions of Interactive SQL and Sybase Central.
10 Requires .NET Compact Framework version 2.0 or 3.5.
11 UltraLite development supported on Windows x86 only.
12 Requires Pocket PC on an ARM processor.
14 Not supported by UltraLite components except UltraLite.NET. Not supported by Smartphone 2002.
15 Not supported by UltraLite components. Static Java API requires JDK 1.2.2 or greater. JDK 1.4 is not supported.
16 Pocket PC 3.0 and higher required.
17 For all systems other than the file sharing system, you must have purchased and installed the appropriate message system software for SQL Remote to function over this system. SQL Remote does not include the underlying message system software.
18 Set LIBPATH to include the directory containing an installed JRE.
19 AIX 5.3 TL07 or higher required for IPv6 support. Only 64-bit software is supported.
22 Requires Microsoft ActiveSync 3.5 or higher
24 Tested on the following platforms:
- MontaVista Linux 4.0.1 (Linux version 2.6.10_mvl401-pc_target (gcc version 3.4.3 (MontaVista 3.4.3-25.0.70.0501961 2005-12-17)))
- SUSE Linux 10.0 (Linux version 2.6.13 (gcc version 4.0.2))
25 Requires IBM J9 Java virtual machine.
26 Requires HP Transport Optional Upgrade Release (TOUR) 3.1 or higher, available from http://software.hp.com.
27 Requires the following patches (or superseding ones). For Solaris 8: 109322-02, 108434-22, 108435-22, 111721-04. For Solaris 9: 111711-16, 111712-16, 111722-05. Please note that although we list patches for the specific issues that we encounter, it is not an exhaustive list and we recommend that you always install the OS patches suggested by the OS vendor. Only 64-bit software is supported.
28 Requires JRE 1.4.1 or higher
29 For a list of operating systems that the Listener was tested on, please refer to this document.
30 For Windows CE, Solaris x64, AIX, HP-UX, and Linux Itanium: On these platforms you can use the connection, database, and server properties to obtain information or you can monitor your server from a computer running an operating system that supports the SQL Anywhere Console (such as Windows XP/200x, Mac OS X, or Linux).
31 AIX 5.3 requires the IY79612 fix. Please note that although we list patches for the specific issues that we encounter, it is not an exhaustive list and we recommend that you always install the OS patches suggested by the OS vendor.
32 A list of Kerberos clients tested with SQL Anywhere is available here: http://www.sybase.com/detail?id=1061016.
Back to Top
