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
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: delescolle at hotmail dot com
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2025 The PHP Group
All rights reserved.
Last updated: Wed Jul 02 06:01:38 2025 UTC