Preface

version 2003/2004

This documentation covers 4D For ADO version 2003 and version 2004.

4D For ADO 2003 requires the following minimum configurations:

• 4D/4D Server 2003.X

• Mac OS 9.2 or 10.1 and higher

• Windows 98 SE or higher (DBGateway.exe service)

• MDAC 2.6 or higher (Windows that hosts DBGateway.exe service) (http://msdn.microsoft.com/data/mdac/default.aspx)

4D For ADO 2004 requires the following minimum configurations:

• 4D/4D Server 2004.X

• Mac OS X 10.2.X or higher

• Windows 2000 or higher (DBGateway.exe service)

• MDAC 2.6 or higher (Windows that hosts DBGateway.exe service) (http://msdn.microsoft.com/data/mdac/default.aspx)

4D for ADO organizes an original technical architecture to open 4D applications (Windows and Mac OS) to the largest choice of connectivity options:

• Through OLEDB:

Active Directory Service
Advantage
AS/400 (from IBM)
AS/400 and VSAM (from Microsoft)
Commerce Server
DB2
DTS Packages
Exchange
Excel
Internet Publishing
Index Server
Microsoft Jet
Microsoft Project
MySQL
ODBC Databases
OLAP Services
Oracle (from Microsoft)
Oracle (from Oracle)
Pervasive
Simple Provider
SQLBase
SQL Server
SQL Server via SQLXMLOLEDB
Sybase Adaptive Server Anywhere
Sybase Adaptive Server Enterprise
Text Files
UniData and UniVerse
Visual FoxPro

• Through ODBC drivers:

Access
AS/400
dBASE
Excel
Informix
Interbase (from Easysoft)
Interbase (from InterSolv)
Lotus Notes
Mimer
MySQL
Oracle (from Microsoft)
Oracle (from Oracle)
Paradox
SQL Server
Sybase
Sybase SQL Anywhere
Text
Teradata
Visual FoxPro

4D for ADO uses an efficient, internal TCP/IP based protocol to provide fast communication between the 4D for ADO plugin and the DBGateway.exe service which can be placed server side or on any Windows box in the network.

DBGateway handles fast communication from your 4D application (in the local network or via Internet), then takes care of ADO communication with the target data sources.