SQL Server

See also: Server - Technical Overview, Engine - SQL-92, VistaDB Server, What You Get

The VistaDB Server is an optional backend SQL database server for managing VistaDB .VDB databases on a remote machine. It supports the same .VDB databases as the default embedded engine.

VistaDB Server runs as a Windows Service or as a console application to provide high-speed client/server SQL support in a shared network environment, on a LAN or over the Internet to applications developed using VistaDB components. Client applications communicate with the VistaDB Server over a high-speed, secure TCP/IP protocol.

Developers use one of the VistaDB editions (.NET, VCL or OLE DB) to create client applications that connect to the VistaDB Server. A VistaDB client application can continue to use the VistaDB embedded engine for managing data locally and can dynamically switch to a client server configuration with only 5 lines of code!

Set the IP address, port #, user name and password in your client application and developers can harness the power of a true client/server architecture.

VistaDB Server SDL and UDL editions support an unlimited number of concurrent client connections. The free 2-User edition supports up to 2 concurrent users, which is ideal for testing and for simply accessing data remotely over TCP/IP. Like the embedded engine, the VistaDB Server application has a very small 200KB footprint. Combined with the embedded engine, the total footprint for the VistaDB Server is only 700KB.