ODBC Database Structure -- dotnet odbc.net

Mark
9/27/2004 4:53:02 PM

Hello.
Does anyone know how to get to the database structure using an ODBC
connection string and retrieve information about tables, fields and data
types etc and display them in tree view.
I am able to do this with OLEDB but Need to do this with ODBC as well.
Any pointers would be much appreciated.

Thanks in advance.

Bob Beauchemin
9/27/2004 9:32:21 PM

Hi Mark,

It's not "natively" available until ADO.NET 2.0, which is now in beta.
Here's an article on 2.0's implementation:

http://msdn.microsoft.com/data/archive/default.aspx?pull=/library/en-us/dnvs05/html/adonet2schemas.asp

I've heard that some folks have written PInvoke wrappers to call SQLTable,
etc, directly.

Bob Beauchemin
http://staff.develop.com/bobb

[quoted text, click to view]

dotnet odbc.net : ODBC Database Structure