User's Guide

Part I. Introduction to SQL Anywhere

Chapter 3. Overview of SQL Anywhere

SQL Anywhere supports situations in which client applications and the database engine run under different operating systems on the same computer. This support requires a SQL Anywhere Client (DBCLIENT) for the client application operating system. You can think of the mixed operating system setup as a client/server network arrangement, with both client and server sides residing on the same computer.

The situations where this can occur are:

• DOS or Windows client applications with an OS/2 engine
• DOS or Windows 3.x client applications with a Windows 95 or Windows NT engine

Mixed operating systems can occur when running DOS or Windows 3.x client applications with a Windows 95 or Windows NT engine

DOS or Windows client applications on OS/2

The OS/2 standalone engine or network server can be accessed from a DOS or WIN-OS/2 client application on the same machine.

The client application communicates with the SQL Anywhere Client for the client application operating system. (The DOS and Windows 3.x SQL Anywhere Clients are installed with SQL Anywhere for OS/2 or as a separate install with the DESKTOP RUNTIME SYSTEM FOR OS/2.) The SQL Anywhere Client handles the communication with the OS/2 database engine or server using named pipes or DDE.

Command lines for DOS or Windows 3.x clients

The command line to run the DOS client is:

dbclient engine-name

The command line to run the Windows 3.x client is:

dbclienw engine-name

Other servers

SQL Anywhere also supports access to network servers elsewhere on the network simultaneously via a separate communication link in the SQL Anywhere Client.

  For more complete information, see the SQL Anywhere Network Guide.

DOS or Windows 3.x clients on Windows 95 or NT

The Windows 95 or Windows NT database engine or server can be accessed from a DOS or Windows 3.x client application on the same machine.

The client application communicates with the SQL Anywhere Client for the client application operating system. (The DOS and Windows SQL Anywhere Clients are installed with SQL Anywhere.) The SQL Anywhere Client handles the communication with the Windows 95 or Windows NT database engine or server, using named pipes (Windows NT) or DDE (Windows 95).

Command lines for DOS or Windows 3.x SQL Anywhere clients

The command line to run the DOS SQL Anywhere Client is:

dbclient engine-name

The command line to run the Windows 3.x SQL Anywhere Client is:

dbclienw engine-name

Other servers

SQL Anywhere also supports access to network servers elsewhere on the network simultaneously via a separate communication link in the SQL Anywhere Client.

  For more information, see the SQL Anywhere Network Guide.