Introducing SQL Anywhere Studio
SQL Anywhere Studio Supported Platforms
The following tables list the supported operating systems for various components of SQL Anywhere Studio.
Unless otherwise noted, the supported versions of the listed operating systems are as described in Operating system versions.
System requirements depend on the database size, workload, and required performance. The following are minimal requirements only. They apply to both the personal database server and the network database server:
Hardware An Intel 486 or higher CPU, or compatible CPU, is required as a minimum. For UNIX systems, the required CPU is operating-system dependent.
Memory Adaptive Server Anywhere can run with as little as 4 MB of memory with an additional 8 KB per client connection. If you use Java in the database, Adaptive Server Anywhere requires an additional 5 MB of memory. Your computer must have this much memory in addition to the requirements for the operating system.
| Component | Windows (32-bit) | Windows (64-bit) | Windows CE | NetWare |
|---|---|---|---|---|
| Personal database server |
|
|
||
| Network database server |
|
|
|
|
| ODBC clients |
|
|
1
|
|
| OLE DB clients |
|
|
|
|
| Embedded SQL clients |
|
|
|
|
| Open Client clients |
|
|
||
| JDBC clients (jConnect) |
|
32-bit software | ||
| JDBC clients (iAnywhere JDBC driver) |
|
|
||
| SQL preprocessor |
|
32-bit software | ||
| Java in the database |
|
|
||
| Remote data access 2 |
|
|
|
|
| External stored procedures |
|
3 |
|
|
| Dynamic cache resizing |
|
|
|
|
| Strong encryption |
|
|
|
|
| CREATE DATABASE, RESTORE DATABASE, DROP DATABASE statements |
|
|
|
|
| SPX protocol |
|
|
| Component | Windows NT / 2000 / XP | Windows (64-bit) | Windows 98 SE | Windows CE | NetWare |
|---|---|---|---|---|---|
| SQL preprocessor (Embedded SQL only) |
|
|
|
||
| UltraLite generator (static C++ API, static Java API) |
|
|
|||
| UltraLite for AppForge MobileVB |
|
||||
| UltraLite ActiveX |
|
||||
| Native UltraLite for Java |
|
||||
| UltraLite.NET | 4 |
||||
| UltraLite for C++ | |
For information about deployment platforms, see UltraLite target platforms.
You can use one of the following development environments to build UltraLite Palm applications:
Metrowerks CodeWarrior version 8 or 9.
See Developing UltraLite applications with Metrowerks CodeWarrior.
CodeWarrior includes a version of the Palm SDK. Depending on the particular devices you are targeting, you may want to upgrade your Palm SDK to a more recent version than that included in the development tool.
AppForge MobileVB, using the UltraLite MobileVB component.
For information on supported development tools for Palm OS targets, see Development environments.
| Component | Windows (32-bit) | Windows (64-bit) | Windows CE | NetWare |
|---|---|---|---|---|
| MobiLink synchronization server |
|
|
||
| TCP/IP synchronization |
|
|
||
| HTTPS synchronization |
|
|
||
| HTTP synchronization |
|
|
||
| Transport-Layer Security |
|
|||
| Java synchronization logic |
|
32-bit software | ||
| .NET synchronization logic |
|
|
| Component | Windows (32-bit) | Windows (64-bit) | Windows CE | NetWare |
|---|---|---|---|---|
| ASA MobiLink clients (dbmlsync) |
|
|
|
|
| TCP/IP synchronization |
|
|
|
|
| HTTP synchronization |
|
|
|
|
| HTTPS synchronization |
|
|
|
|
| Transport-layer security |
|
|
|
| Component | Windows (32-bit) | Windows (64-bit) | Windows CE | NetWare |
|---|---|---|---|---|
| Redirector |
5
|
|||
| MobiLink extraction utility (mlxtract) |
|
|
SQL Remote components that operate against Adaptive Server Enterprise databases require Sybase Open Client and/or Open Server libraries.
| Component | Windows (32-bit) | Windows (64-bit) | Windows CE | NetWare |
|---|---|---|---|---|
| ASA Message Agent (dbremote) |
|
|
|
|
| ASE Message Agent (ssremote) |
|
32-bit software | ||
| ASE stable queue (ssqueue) |
|
32-bit software | ||
| ASA extraction utility (dbxtract) |
|
|
||
| ASE extraction utility (ssxtract) |
|
32-bit software | ||
| File message type |
|
|
|
|
| FTP message type |
|
|
|
|
| MAPI message type |
|
|
||
| SMTP message type |
|
|
|
|
The Replication Agent requires Sybase Open Client and Open Server libraries.
| Component | Windows (32-bit | Windows (64-bit) | Windows CE | NetWare |
|---|---|---|---|---|
| Replication Agent |
|
32-bit software |
| Component | Windows (32-bit) | Windows (64-bit) | Windows CE | NetWare |
|---|---|---|---|---|
| Command line administration utilities |
|
|
|
|
| Sybase Central |
|
32-bit JRE | ||
| Interactive SQL |
|
32-bit JRE |
6 |
|
| DBConsole |
|
32-bit JRE |
7 |
With the exception of the command-line administration utilities and the tools provided on NetWare, the administration tools employ a Java 2 runtime environment, version 1.4.1.
The following paragraphs are taken from the Java 2 SDK, Standard Edition documentation, and apply to the administration tools:
The Java™ 2 SDK is intended for use on Microsoft Windows 95, 98 (1st or 2nd edition), NT 4.0 with Service Pack 5, Me, 2000 Professional, 2000 Server, 2000 Advanced Server, or XP operating systems running on Intel hardware.
A Pentium 166MHz or faster processor with at least 32 megabytes of physical RAM is required to run graphically based applications. Forty-eight megabytes of RAM is recommended for applets running within a browser using the Java Plug-in product. Running with less memory may cause disk swapping which has a severe effect on performance. Very large programs may require more RAM for adequate performance.
You should have 70 megabytes of free disk space before attempting to install the Java 2 SDK software. If you also want to install the documentation download bundle, you will need an additional 120 megabytes of free disk space.
In non-English locales, only the Professional edition of Windows 2000 is supported.
1 ODBC driver manager may not be available. May have to link directly to ODBC driver.
2 Requires iAnywhere Solutions ODBC driver. For a list of supported platforms, see iAnywhere Solutions ODBC drivers supported platforms.
3 The older interface to external stored procedures is available only in 32-bit software.
4 Requires Visual Studio.NET with .NET Compact Framework version 1.0.5000 or later.
5 Windows NT/2000/XP only
6 A more limited version than is provided on other operating systems
7 A more limited version than is provided on other operating systems