ODBC Data Sources

  • Thread starter Thread starter Landley
  • Start date Start date
L

Landley

Hi All,

Is there a method that I can call to return a list of available database
drivers?

If so, is there then a way to get the list of fields that are required for
those the database drivers?

L.
 
Thanks for your reply.

I cannot see what I am looking for here.

All I am after is some sample .NET code (C# or VB.NET) illustrating how to
retrieve a list of ODBC database drivers available on the local machine.
This is the list that you can see in the ODBC Data Source Administrator
(odbcad32) dialog.

I am then after some sample code to ascertain what parameters each driver
requires in order to create a valid connection.

Any ideas?

L.
 
The URL won't help much--it just shows examples of typical (and some pretty
bizarre) connectionstrings.
I've seen (new) ADO.NET 2.0 factory classes to generate a list of providers
in ADO.NET, but I have never seen anything but (widely) scattered documents
that tell what parameters the connection strings take.


--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
 
Bill,
but I have never seen anything but (widely) scattered documents that tell
what parameters the connection strings take.
Click to expand...
Maybe something nice for your pages, I think that you have than have a very
much visited site and that this connection string site loose.

I have searched as well often for that.

Just an idea and it is free.

:-)))

Cor
 
¤ Hi All,
¤
¤ Is there a method that I can call to return a list of available database
¤ drivers?
¤

You would probably need to enumerate the following registry entry:

HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBCINST.INI\ODBC Drivers

¤ If so, is there then a way to get the list of fields that are required for
¤ those the database drivers?

I don't believe this information is stored anywhere.


Paul
~~~~
Microsoft MVP (Visual Basic)
 
Back
Top