[Firebird-devel] [ firebird-Bugs-939208 ] Can't using 'SHOW TABLE;' for ODBC 1.2 beta with ADO

[SourceForge.net <no...@so...>]

Bugs item #939208, was opened at 2004-04-21 10:43
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=939208&group_id=9028

Category: ODBC/JDBC Driver
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: abcfirebird (abcfirebird)
Assigned to: Nobody/Anonymous (nobody)
Summary: Can't using 'SHOW TABLE;'  for ODBC 1.2 beta with ADO

Initial Comment:
I developing an application by using VB 6.0, Firebird 
Server 1.5 Final, Firebird ODBC 1.2 beta, ADO. But  when 
i using ADO follow:

conn.Open ("DRIVER=Firebird/InterBase(r) 
driver;DBNAME=mydata; UID=SYSDBA; 
PWD=masterkey;")
set rs = conn .execute("SHOW TABLE;")
when rs as ADODB.Recordset
        conn as ADODB.Connection
        mydata as a database that i config in aliases.conf

From above this code have an error follow:
	Dynamic SQL Error
	SQL error code= -104
	Token unknow - line1, char 1
	SHOW

But i using this command "SHOW TABLE;" in firebird 
engine ("isql.exe"). It work.
Help me please, I should do?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=109028&aid=939208&group_id=9028