ID: 22997
Updated by: [EMAIL PROTECTED]
Reported By: jslave at jslave dot com
-Status: Open
+Status: Bogus
Bug Type: ODBC related
Operating System: windows 2000
PHP Version: 4.3.0
New Comment:
Works fine. Please read how the odbc_connect() function works.
Previous Comments:
------------------------------------------------------------------------
[2003-03-31 23:44:25] 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
(
)
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=22997&edit=1
