HighTechTalks DotNet Forums  

Retrieving table names in database via ODBC in C#

Dotnet Framework (ODBC.net) microsoft.public.dotnet.framework.odbcnet


Discuss Retrieving table names in database via ODBC in C# in the Dotnet Framework (ODBC.net) forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
simon.coates (AT) tribune (DOT) co.uk
 
Posts: n/a

Default Retrieving table names in database via ODBC in C# - 04-15-2005 , 08:43 AM






Hi,

I need to be able to query an ODBC database and return a list of the
tables contained within it, via ODBC. I gather from other posts in this
group that it is not currently possible to do this via ODBC in the
current .NET framework. Does anyone know if this is likely to change in
..NET 2?

Kind regards


Simon Coates


Reply With Quote
  #2  
Old   
Paul Clement
 
Posts: n/a

Default Re: Retrieving table names in database via ODBC in C# - 04-18-2005 , 12:27 PM






On 15 Apr 2005 05:43:31 -0700, "simon.coates (AT) tribune (DOT) co.uk" <simon.coates (AT) tribune (DOT) co.uk> wrote:

¤ Hi,
¤
¤ I need to be able to query an ODBC database and return a list of the
¤ tables contained within it, via ODBC. I gather from other posts in this
¤ group that it is not currently possible to do this via ODBC in the
¤ current .NET framework. Does anyone know if this is likely to change in
¤ .NET 2?

I will have to check to see if they have updated the ODBC provider. AFAIK this feature is currently
only supported under OLEDB.

The alternative is to use a stored proc or SQL statement that is specific to the type of database
you are working with.


Paul
~~~~
Microsoft MVP (Visual Basic)

Reply With Quote
  #3  
Old   
Cindy Winegarden
 
Posts: n/a

Default Re: Retrieving table names in database via ODBC in C# - 04-18-2005 , 09:45 PM



Hi Simon,

ODBC is a deprecated technology so you're not likely to see any ODBC-related
improvements in .NET 2.0.

--
Cindy Winegarden MCSD, Microsoft Visual Foxpro MVP
cindy_winegarden (AT) msn (DOT) com www.cindywinegarden.com
Blog: http://spaces.msn.com/members/cindywinegarden


<simon.coates (AT) tribune (DOT) co.uk> wrote

Quote:
Hi,

I need to be able to query an ODBC database and return a list of the
tables contained within it, via ODBC. I gather from other posts in this
group that it is not currently possible to do this via ODBC in the
current .NET framework. Does anyone know if this is likely to change in
.NET 2?



Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.