php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #1125 odbc_execute() and odbc_exec() report errors while odbc_prepare() returns ok
Submitted: 1999-02-08 04:56 UTC Modified: 1999-07-11 04:37 UTC
From: delescolle at hotmail dot com Assigned:
Status: Closed Package: ODBC related
PHP Version: 3.0.6 OS: Wiindows NT 4.0
Private report: No CVE-ID: None
 [1999-02-08 04:56 UTC] delescolle at hotmail dot com
The SQL code is:
select * from Problems where ((Code-s-c = "C"))
<?
$conn = odbc_connect(dsn,user,pwd);
$line = odbc_prepare($conn, "SQL code");
---> Works fine until:
$result = odbc_execute($line);
?>

Any 'simple' sql request like "select * from problems" works fine. It seems that only statements with "where" cause trouble.

The ODBC error:
Warning: SQL error: [Microsoft][ODBC Microsoft Access 97 Driver] Trop peu de param?tres.
3 attendu., SQL state 07001 in SQLExecDirect in c:\program files\apache
group\apache\htdocs/go.phtml on line 23

As you can see from the error the "problems" database is an Access Database.

My php3.ini file is the regular one that I built following the installation instructions.


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [1999-07-11 04:36 UTC] kara at cvs dot php dot net
Reverted to simpler functions as of PHP 3.0.10 which should 
solve these problems but disables absolute fetching of results.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Thu Apr 18 03:01:28 2024 UTC