Development

4D Standard Edition | 4D Developer Edition | 4D Server Standard | 4D Server Developer

Deployment

4D Plug-Ins

4D Productivity | 4D Connectivity | 4D SDK

Sonstiges

4D Handbücher | 4D Services

Preisliste

Preise

ODCB Driver for 4D Server

ODBC driver for 4D Server v6.8 allows client applications to communicate with 4D Server via SQL commands

Most Windows applications are able to communicate with other data sources via an interface called Open Database Connectivity (ODBC). This interface uses the SQL standard to execute queries.

With ODBC Driver for 4D Server, many types of applications (word-processors, spreadsheets, report generators, etc.) running on Windows may access 4D Server to carry out database tasks. 4D ODBC Driver for 4D Server allows client applications to send ODBC calls and SQL queries to 4D Server.

ODBC Driver for 4D Server transforms a 4D Server application into an ODBC data source, thereby providing access to all standard Windows applications. These Windows applications may execute ODBC calls and SQL queries, as well as standard operations such as printing mail merge letters, generating reports, and displaying data in a spreadsheet, a word-processor, or a database.

Any 4D Server (Mac OS or Windows) can be an ODBC source: but the client can only run on Windows.

Features

The ODBC driver for 4D Server does not require changes to be made to a 4D Server database.

All connections via the driver are handled as fully functional 4D Server client connections.
Support for ODBC version 2.5.
Total control over data manipulation in 4D Server (SELECT, INSERT, UPDATE, DELETE).
Standard ODBC error management.
Driver access available to custom C or C++ applications.