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
