Retrieving Schema info for connection

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Terry Olsen - 27 Dec 2006 05:21 GMT

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?

Reply to this Message

krishnen - 27 Dec 2006 14:40 GMT

Terry,

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

Krishnen

> 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
[quoted text clipped - 6 lines]
>
> Is there a way to get database names from an ODBC connection?

Reply to this Message

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...