Bug #1125: odbc_execute() and odbc_exec() report errors while odbc_prepare() returns ok

From: delescolle@hotmail.com Operating system: Wiindows NT 4.0 PHP version: 3.0.6 PHP Bug Type: ODBC related Bug description: odbc_execute() and odbc_exec() report errors while odbc_prepare() returns ok 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. -- PHP Development Mailing List http://www.php.net/ To unsubscribe send an empty message to php-dev-unsubscribe@lists.php.net For help: php-dev-help@lists.php.net