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

[quoted text, click to view]

¤ 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
~~~~

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

thanks

[quoted text, click to view]