ODBC Data Sources

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
Sat Jun 25 03:37:34 CDT 2005

Landley,

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

www.connectionstring.com

Cor

Landley
Mon Jun 27 17:35:21 CDT 2005

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" <notmyfirstname@planet.nl> wrote in message
news:OIraBFWeFHA.3864@TK2MSFTNGP10.phx.gbl...
> Landley,
>
> If I understood you well, than use most people this very famous webpage.
>
> www.connectionstring.com
>
> Cor
>
>

William
Mon Jun 27 18:24:18 CDT 2005

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" <news@creations-software.co.uk> wrote in message
news:%23TJSCi2eFHA.2692@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" <notmyfirstname@planet.nl> wrote in message
> news:OIraBFWeFHA.3864@TK2MSFTNGP10.phx.gbl...
>> Landley,
>>
>> If I understood you well, than use most people this very famous webpage.
>>
>> www.connectionstring.com
>>
>> Cor
>>
>>
>
>

Cor
Tue Jun 28 02:50:59 CDT 2005

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
Tue Jun 28 12:03:27 CDT 2005

On Fri, 24 Jun 2005 23:24:56 +0100, "Landley" <news@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)