RE: [PHP-DB] Anyone used Merant Data Direct?

David, I've seen some problems with odbc_do and odbc_exec. These are both 'Directly Executing' statements, without preparing them first. One workaround for the time being is to use odbc_prepare with odbc_execute, which works fine. I am looking into how PHP changed the odbc handling from 3 to 4, as this seems to be what changed. Best regards, Andrew ---------------------------------------------------- Andrew Hill Professional Services Consultant OpenLink Software http://www.openlinksw.com Universal Database Connectivity Technology Providers -----Original Message----- From: David Osborne [mailto:David.Osborne@nottingham.ac.uk] Sent: Friday, June 30, 2000 5:05 AM To: Andrew Hill Subject: RE: [PHP-DB] Anyone used Merant Data Direct? Andrew (from the php-db list)... On Wed, 21 Jun 2000, Andrew Hill wrote: AH> Openlink's Data Access Drivers version 4 will be released next week, and are AH> ODBC 3.5 compliant. Are the drivers available yet? The download pages on the Web seem to show only version 3.2 at the moment. We have a licenced copy of Openlink ODBC drivers and request broker for CA OpenIngres 2.0, which we're using successfully with PHP 3.0.16 on Solaris 2.7. However, I'm just switching to PHP 4.0.0 and an attempt to use the same ODBC drivers fails with Warning: SQL error: [OpenLink][ODBC][Driver]General error, SQL state S1000 in SQLExecDirect in /home/cczdao/public_html/sysreg/php_old/gateways.php4 on line 13 If executed using PHP3 (via an appropriately-named symlink), the same PHP page works correctly. I'm guessing that I might need a newer release of the ODBC software. It would have been useful to determine the release we're currently using with PHP3, but I can't find that info in the unpacked files. This is an urgent problem as I'm developing to a deadline and need the session support in PHP4. Let me know if you need any supplementary information for this problem. Thanks. regards David -- David Osborne david.osborne@nottingham.ac.uk Academic Computing Services phone/voicemail: +44 (0)115 951 3397 The University of Nottingham fax: +44 (0)115 951 3358 Nottingham NG7 2RD, UK http://www.nottingham.ac.uk/~cczdao/