1

I have developed an application using 4D database. But I want to connect any database client to my 4D database for querying the tables (in which I am comfortable of).

I know that I can use sql in 4D database too but my requirement here is to query the 4D database tables with database client because in 4D I have to store the values obtained from query into variables/listview.

Is this possible? If yes, then how can I do that?

Tim Penner
  • 3,551
  • 21
  • 36
Suniel
  • 1,449
  • 8
  • 27
  • 39

1 Answers1

2

4D Client

You could (obviously) use the native 4D Client to connect to 4D Server.

4D ODBC

You could use ODBC to connect to 4D Server from a generic client.

You would need to install the 4D ODBC Driver appropriate to your environment on the client machine. Remember to match the version of ODBC Driver to the version of 4D and the architecture of the ODBC Driver with the architecture of the ODBC Client.

For example, if your 4D Server is running v15.2 and the generic client is running in 64 bit mode, you would then want to use the 4D v15.2 ODBC Driver 64 bit

On the other hand if 4D Server is running 14.5 and the generic client is running in 32 bit mode, you would want to install the 4D v14.5 ODBC Driver 32 bit

The ODBC Drivers can be downloaded from http://4d.com/downloads/products.html

4D Native SQL Protocol

The 4D SQL Protocol is documented at Github - 4D/SQLlib_4D and also on sources.4d.com so theoretically you could write a native connector of some sort.

Community
  • 1
  • 1
Tim Penner
  • 3,551
  • 21
  • 36
  • Thanks, 4D ODBC works as per my requirement. I installed the 4D ODBC Driver and use RazorSql as client which connect to 4D database via ODBC driver. – Suniel May 24 '16 at 12:03