php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #22997 SEEMS TO NOT SUPPORT LATEST MDAC
Submitted: 2003-03-31 23:44 UTC Modified: 2003-04-01 09:01 UTC
From: jslave at jslave dot com Assigned:
Status: Not a bug Package: ODBC related
PHP Version: 4.3.0 OS: windows 2000
Private report: No CVE-ID: None
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: jslave at jslave dot com
New email:
PHP Version: OS:

 

 [2003-03-31 23:44 UTC] jslave at jslave dot com
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 
( 
)

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-04-01 09:01 UTC] kalowsky@php.net
Works fine.  Please read how the odbc_connect() function works.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved.
Last updated: Thu Jul 03 10:01:33 2025 UTC