php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #6901 odbc_columns
Submitted: 2000-09-27 06:32 UTC Modified: 2002-05-28 16:56 UTC
From: john dot cumming at hither dot com Assigned: kalowsky (profile)
Status: Closed Package: ODBC related
PHP Version: 4.0.1pl2 OS: Win98SE
Private report: No CVE-ID: None
View Developer Edit
 [2000-09-27 06:32 UTC] john dot cumming at hither dot 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

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2001-02-14 08:19 UTC] kalowsky@php.net 
starting to play with odbc on windows... all i have is 98 though...
 [2001-03-16 08:38 UTC] 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.
 [2002-05-28 16:56 UTC] kalowsky@php.net 
Finally found documentation saying that MSAccess engine doesn't fully support this.  Marking as closed as it's not a PHP program.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Tue May 06 16:01:28 2025 UTC