Bug #6901 Updated: odbc_columns

ID: 6901 Updated by: kalowsky@php.net Reported By: john.cumming@hither.com -Status: Analyzed +Status: Closed Bug Type: ODBC related Operating System: Win98SE PHP Version: 4.0.1pl2 Assigned To: kalowsky New Comment: Finally found documentation saying that MSAccess engine doesn't fully support this. Marking as closed as it's not a PHP program. Previous Comments: ------------------------------------------------------------------------ [2001-03-16 08:38:18] kalowsky@php.net This bug is very similar in nature to #6275, but not the same. It seems the SQLBindColumn option is not happy with some of the MSAccess stuff. I've just recently tried updating to MDAC 2.6, and will see if this fixes anything. Yes this is still valid in the current versions of CVS as well. Mind you it seems to be an MSAccess only issue. ------------------------------------------------------------------------ [2001-02-14 08:19:53] kalowsky@php.net starting to play with odbc on windows... all i have is 98 though... ------------------------------------------------------------------------ [2000-09-27 06:32:41] john.cumming@hither.com Hi, I am using the pre-built version of PHP 4.0.1pl2 on Win98. and connecting to a MSAccess data source with ODBC. This code fragment works, $result = odbc_columns($link); while this on does not, $result = odbc_columns($link, "%", "%", "%", "%"); it generates, Warning: SQL error: ,SQL state 00000 in SQLColumns in ... I get the same error message with, $result = odbc_tables($link, "%", "%", "%", "%" ); I hope this is helpful. -John ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=6901&edit=1