Is there any way to retrieve table list from ODBC datasource?
I think .NET does not have this ability, may be ODBC SDK download and
install can help?
For example, if i connect to ODBC datasource via DSN, can i retrieve all
tables?

[quoted text, click to view]

¤ Is there any way to retrieve table list from ODBC datasource?
¤ I think .NET does not have this ability, may be ODBC SDK download and
¤ install can help?
¤ For example, if i connect to ODBC datasource via DSN, can i retrieve all
¤ tables?
¤

If you're using the OLEDB provider you can use GetOleDbSchemaTable. The ODBC provider does not have
support for querying database schema information. You would need to use SQL or a stored procedure
(depends upon the database) that can retrieve this information.


Paul ~~~ pclement@ameritech.net