Development

4th Dimension Standard Edition | 4D Developer Edition | 4D Server Standard Edition | 4D Server Developer Edition | 4D Web 2.0 Pack

Deployment

4D Deployment Options | 4D Runtime Volume | 4D Server Application | 4D Web Server 4D Web Services Server

Solution Accelerators

4D Meetings

4th Dimension 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.