Retrieving Schema info for connection

[Terry Olsen]

I'm building a program to navigate through a database. The user chooses
either ODBC or OleDb and provides a connection string. With OleDb I can get
the database names from the connection. Is there a way I can do this with an
ODBC connection? Programs like DTM Data Editor can do it. But there doesn't
seem to be a way in .NET 2.0.

Or can I get enough information from the ODBC connection to create an OleDb
connection?

Is there a way to get database names from an ODBC connection?

 

[krishnen]

Terry,

You can know the database name from the OdbcConnection object itself
from the property Database

Krishnen