They are two different implementations of IDBConnection. SqlConnection is
the SqlServer implementation, OleDb was everything 'else' . That's been
minimized to some degree since the addition of the ODBC and Oracle libraries
in the 1.1 framework so OleDbConnection should probably be renamed to
PeopleWhoStillUseMSAccessConnection
The answer to your question though. Back in the old school days, a bunch of
VB programmers started whining b/c data access was too hard. So Microsoft
came out with ODBC which was an agreed upon spec that you could use to
access any database that complied with it. They still complained that it
was still to hard. So they came up with OleDB, the next version of
DataAccessForEveryone. From there things morphed into ADO and then more
recently ADO.NET. But basically it's just a spec that vendors can agree or
not agree to abide by, most have but some haven't.
Bill
--just joking about the VB Programmers, it's a running joke with a few
people that read this NG regularly.
"cody" <pl*************************@gmx.de> wrote in message
news:Oc**************@TK2MSFTNGP11.phx.gbl...
What is the difference between OleDBConnection and SqlConnection?
Or better expressed, what is OleDB?
--
cody
[Freeware, Games and Humor]
www.deutronium.de.vu || www.deutronium.tk