how do i get a list of tables after issuing odbcconnection.open? i'm able to
open the connection and use odbcconnection.getschema but is there a generic
method that returns table list?

thanks

On Sun, 28 May 2006 21:25:45 -0400, "gyoder" <georgeyoder (AT) comcast (DOT) net> wrote:

¤ how do i get a list of tables after issuing odbcconnection.open? i'm able to
¤ open the connection and use odbcconnection.getschema but is there a generic
¤ method that returns table list?
¤

Dim ODBCDatabaseConnection As New Odbc.OdbcConnection

ODBCDatabaseConnection.ConnectionString = "DSN=AccessDB"
ODBCDatabaseConnection.Open()

Dim TableSchema As DataTable

TableSchema = ODBCDatabaseConnection.GetSchema("tables")

DataGridView1.DataSource = TableSchema

ODBCDatabaseConnection.Close()


Paul
~~~~
Microsoft MVP (Visual Basic)

I needed the same thing, and this post helped me.

thanks
Jd

"J T" wrote: