#22997 [NEW]: SEEMS TO NOT SUPPORT LATEST MDAC

From: jslave at jslave dot com Operating system: windows 2000 PHP version: 4.3.0 PHP Bug Type: ODBC related Bug description: SEEMS TO NOT SUPPORT LATEST MDAC Hi, I have a simple test script that works on a system with pre-.net MDAC, but on my development system which runs a newer MDAC (installed with VS.NET), I get errors. The newest MDAC I am using is 3.520.7713.0 Is this supported? The example below uses ADODB, but the ADODB team suggetsed it should be reported here as its an ODBC issue. TestScript: $database="access"; $server="magazines"; $user=""; $password=""; include('adodb/adodb.inc.php'); $db = ADONewConnection($database); $db->debug = true; $db->Connect($server, $user, $password, $database); $rs = $db->Execute('select * from magazine'); print "<pre>"; print_r($rs->GetRows()); print "</pre>"; I have the code below for reference. Error Output: For odbc Connect(), access is not used. Place dsn in 1st parameter. Warning: SQL error: , SQL state 00000 in SQLConnect in C:\aaaa\Projects\PLIB\PLIB\members\adodb\drivers\adodb-odbc.inc.php on line 150 magazines: -------------------------------------------------------------------------------- (access): select * from magazine -------------------------------------------------------------------------------- Warning: odbc_exec(): supplied argument is not a valid ODBC-Link resource in C:\aaaa\Projects\PLIB\PLIB\members\adodb\drivers\adodb-odbc.inc.php on line 445 00000: Array ( ) -- Edit bug report at http://bugs.php.net/?id=22997&edit=1 -- Try a CVS snapshot: http://bugs.php.net/fix.php?id=22997&r=trysnapshot Fixed in CVS: http://bugs.php.net/fix.php?id=22997&r=fixedcvs Fixed in release: http://bugs.php.net/fix.php?id=22997&r=alreadyfixed Need backtrace: http://bugs.php.net/fix.php?id=22997&r=needtrace Try newer version: http://bugs.php.net/fix.php?id=22997&r=oldversion Not developer issue: http://bugs.php.net/fix.php?id=22997&r=support Expected behavior: http://bugs.php.net/fix.php?id=22997&r=notwrong Not enough info: http://bugs.php.net/fix.php?id=22997&r=notenoughinfo Submitted twice: http://bugs.php.net/fix.php?id=22997&r=submittedtwice register_globals: http://bugs.php.net/fix.php?id=22997&r=globals PHP 3 support discontinued: http://bugs.php.net/fix.php?id=22997&r=php3 Daylight Savings: http://bugs.php.net/fix.php?id=22997&r=dst IIS Stability: http://bugs.php.net/fix.php?id=22997&r=isapi Install GNU Sed: http://bugs.php.net/fix.php?id=22997&r=gnused