iAnywhere.com - Windows and NetWare operating systems

Windows and NetWare operating systems

The following tables list the supported operating systems for various components and features of SQL Anywhere Studio.

Unless otherwise noted, the supported versions of the listed operating systems are as described in Operating system versions.

Adaptive Server Anywhere

System requirements depend on the database size, workload, and required performance. The following are minimal requirements only.

Adaptive Server Anywhere (both personal database server and network database server) can run with as little as 4 MB of memory with an additional 8 KB per client connection. More memory will improve performance significantly. 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 or Feature	Windows (64-bit)	Windows CE	NetWare
Personal database server
Network database server
ODBC clients		¹
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 ²			³
External stored procedures	⁴
Dynamic cache resizing
Strong encryption
CREATE DATABASE, RESTORE DATABASE, DROP DATABASE statements
SPX protocol

UltraLite development platforms

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	⁵
UltraLite for C++

Although most 32-bit software works under emulation in 64-bit Windows, the static Java API is not available on 64-bit Windows.

For information about deployment platforms, see UltraLite target platforms.

Development environments

You can use one of the following development environments to build UltraLite applications for Palm OS:

Metrowerks CodeWarrior version 8 or 9.

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 or Crossfire, using the UltraLite MobileVB component.

MobiLink synchronization server

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
MobiLink with Messaging (QAnywhere)
Server-Initiated Synchronization

MobiLink Adaptive Server Anywhere clients

Component	Windows (32-bit)	Windows (64-bit)	Windows CE	NetWare
ASA MobiLink clients (dbmlsync)
TCP/IP synchronization
HTTP synchronization
HTTPS synchronization
Transport-layer security
QAnywhere clients

MobiLink utilities

Component	Windows (32-bit)	Windows (64-bit)	Windows CE	NetWare
Redirector	⁶
MobiLink extraction utility (mlxtract)

SQL Remote

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)
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
VIM message type	v

Replication agent

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

Administration tools

Component	Windows (64-bit)	NetWare
Command line administration utilities
Sybase Central	32-bit JRE
Interactive SQL	32-bit JRE	⁷
DBConsole	32-bit JRE	⁸

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.

¹ ODBC driver manager may not be available. May have to link directly to ODBC driver.

² Requires iAnywhere Solutions ODBC driver on Windows. For a list of supported platforms, see iAnywhere Solutions ODBC drivers supported platforms.

³ Requires Java in the database and JDBC driver

⁴ The older interface to external stored procedures is available only in 32-bit software.

⁵ Requires Visual Studio.NET or Visual Studio.NET 2003, with .NET Compact Framework version 1.0.5000 or later.

⁶ Windows NT/2000/XP only

⁷ A more limited version than is provided on other operating systems

⁸ A more limited version than is provided on other operating systems