ODBC Data Sources

[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.

[Cor Ligthert]

Landley,

If I understood you well, than use most people this very famous webpage.

www.connectionstring.com

Cor

[Landley]

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.
"Cor Ligthert" <no************@planet.nl> wrote in message
news:OI**************@TK2MSFTNGP10.phx.gbl...

Landley,

If I understood you well, than use most people this very famous webpage.

www.connectionstring.com

Cor

[William \(Bill\) Vaughn]

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.
__________________________________

"Landley" <ne**@creations-software.co.uk> wrote in message
news:%2****************@tk2msftngp13.phx.gbl...

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.
"Cor Ligthert" <no************@planet.nl> wrote in message
news:OI**************@TK2MSFTNGP10.phx.gbl...

Landley,

If I understood you well, than use most people this very famous webpage.

www.connectionstring.com

Cor

[Cor Ligthert]

Bill,

but I have never seen anything but (widely) scattered documents that tell
what parameters the connection strings take.

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

[Paul Clement]

On Fri, 24 Jun 2005 23:24:56 +0100, "Landley" <ne**@creations-software.co.uk> wrote:

¤ 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)