JeevesBond — Fri, 05 Jan 2007 07:25:03 +0000

As an example of what to pass as a DSN (the first parameter of odbc_connect()) I found the IBM DB2 ODBC driver connection string in an article (good bit's 3/4 way through the article). It looks like this: -
DRIVER={IBM DB2 ODBC DRIVER};HOSTNAME=localhost;DATABASE=dbname;PROTOCOL=TCPIP;PORT=1527;'

JeevesBond — Fri, 05 Jan 2007 07:20:13 +0000

I would guess the answer lies with ODBC; the Windows version of PHP comes with support for ODBC built-in. General information on PHP ODBC functions are available at: http://www.php.net/odbc (there's a useful function list at the bottom).

As far as I can see, you open a connection with an odbc_connect(); query the database using the odbc_exec(); then close the connection using odbc_close().

You iterate through the results in the following manner: -

<?php
while ($row = odbc_fetch_array($result)) {
   echo $row['column_name'];
   ... etc ...
}
?>

The remaining problem is finding out what to pass to the odbc_connect() function, particularly the first argument (the dsn). That's assuming ODBC is available for 4D at all! It should be in the software package somewhere, unfortunately a driver doesn't appear on their web site.

msaz87 — Fri, 05 Jan 2007 04:20:52 +0000

I haven't figured it out yet.. still trying to do it through 4D.

The product, as far as I can tell, is simply 4th Dimension, but 4d.com is their web site.

I posted on here in hopes someone might have an idea through a different methodology.

FrankR — Thu, 04 Jan 2007 23:37:36 +0000

Did you ever figure out what to do? Is 4D a particular database product by http://www.4d.com? I am not clear if it is a standard relational database or something else.