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
View Add Comment Developer Edit
Welcome! If you don't have a Git account, you can't do anything here.
You can add a comment by following this link or if you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved.
Last updated: Fri Apr 26 22:01:29 2024 UTC