Resolve all the db-drivers.

  • Thread starter Thread starter Mr. X.
  • Start date Start date
M

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 :)
 
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.
Click to expand...

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.
 
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
 
If not ODBC (a generic engine for all of the databases), so what should I
use (for generic solution) ?

Thanks :)
 
Back
Top