Resolve all the db-drivers.

[Mr. X.]

Hello.
I need some global solution to handle a situation, I need to connect to any
driver.
It seems that mySql has it's own drivers.
Should it be ODBC?
Is there any way to get the list all the installed db-drivers ?
How can I connect any driver after installed it?
Need sample, please.

Thanks

 

[Armin Zingler]

Am 06.07.2010 22:31, schrieb Mr. X.:

Hello.
I need some global solution to handle a situation, I need to connect to any
driver.
It seems that mySql has it's own drivers.
Should it be ODBC?
Is there any way to get the list all the installed db-drivers ?
How can I connect any driver after installed it?
Need sample, please.

There are some ".Net data providers":
http://msdn.microsoft.com/en-us/library/a6cd7c08(VS.90).aspx

For each there are different ways to enumerate
available sources. You can search for "enumerate oledb providers"
and alike for example.

 

[Cor]

As long as you haven't installed the provider dll's and set a reference to
it.
You won't see it in your VB program.

Be aware that there are build in providers in the frameworks, where version
1.x had the most (reason licenses).

Those are located in the namespace System.Data

I would avoid ODBC in Net, as those are the weakest.

Success

Cor

 

[Mr. X.]

If not ODBC (a generic engine for all of the databases), so what should I
use (for generic solution) ?

Thanks

 

[Cor]

OleDB

If not ODBC (a generic engine for all of the databases), so what should I
use (for generic solution) ?

Thanks