Help using certain commands in VB to access Oracle info 
Author Message
 Help using certain commands in VB to access Oracle info

How can I execute "DESC tablename" in vb using ADO

Thanks

SS



Sun, 29 Jun 2003 05:39:59 GMT  
 Help using certain commands in VB to access Oracle info
You cant, since it is not a SQL statement, only a command in SQL*Plus.

To get catalog info in ADO, you can use objConnection.OpenSchema(....)
which returns recordsets. See the docs.

--
Best regards,

Carlos J. Quintero

Freeware "all-in-one" Add-In for VB6: TabIndex Assistant, Procedure Callers,
Find in All Projects, Close Windows, Review TabIndex, Review Collections,
Add Property or Function, Add Error Handler, Add Header Comment, Clear
Immediate Window, Project Statistics:
www.mztools.com



Quote:
> How can I execute "DESC tablename" in vb using ADO

> Thanks

> SS



Sun, 29 Jun 2003 17:20:08 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Help:How to avoid Oracle Logon window for VB to Oracle via attached Access

2. Accessing Linked Oracle Tables in Access Using ODBC in VB

3. Changing password in Oracle using PASSWORD command via VB app

4. Changing password in Oracle using PASSWORD command via VB app

5. Help: using a scanner to enter info in an Access database

6. AS/400 - Seeking info on using VB to access DB2/400

7. Looking for info on using Access/VB with DB2 on MVS ESA

8. Accessing Oracle Stored procedure output parameter from VB using RDO2.0

9. Using VB to access Oracle

10. Oracle access using VB

11. accessing Oracle databases using VB 4.0 standard edition

12. Accessing Remote Oracle database using VB code.

 

 
Powered by phpBB® Forum Software