471,350 Members | 1,882 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,350 software developers and data experts.

list of dbf tables from odbc connection

Hello

Using c#, is there a way to get a list of table names from odbc dsn dbf
database connection?

Thanks

Martin
Jan 18 '06 #1
2 5104
not sure if this helps
GetOleDbSchemaTable()

"Martin" <tr****************@shaw.ca> wrote in message
news:SEfzf.373939$ki.276932@pd7tw2no...
Hello

Using c#, is there a way to get a list of table names from odbc dsn dbf
database connection?

Thanks

Martin

Jan 18 '06 #2

"Craigm" <cr***@nexdox.com> wrote in message
news:OR**************@TK2MSFTNGP15.phx.gbl...
not sure if this helps
GetOleDbSchemaTable()

"Martin" <tr****************@shaw.ca> wrote in message
news:SEfzf.373939$ki.276932@pd7tw2no...
Hello

Using c#, is there a way to get a list of table names from odbc dsn dbf
database connection?

Thanks

Martin


Thanks Craigm

The visual foxpro driver seems not to support table extraction but with the
odbc schema
I found a link to the dbf folder to tables using,
DataTable schema = conn.GetSchema(OdbcMetaDataCollectionNames.Tables

string directory = schema.Rows[0][0].ToString();

Martin
Jan 18 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Random Person | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.