C
cody
What is the difference between OleDBConnection and SqlConnection?
Or better expressed, what is OleDB?
Or better expressed, what is OleDB?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
W
William Ryan eMVP
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.
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.
C
Chris R. Timmons
What is the difference between OleDBConnection and SqlConnection?
Or better expressed, what is OleDB?
Microsoft OLE DB Reference:
http://msdn.microsoft.com/library/en-
us/oledb/htm/dasdkoledboverview.asp
or
http://tinyurl.com/38olt
..NET Data Access Architecture Guide:
http://msdn.microsoft.com/library/default.asp?url=/library/en-
us/dnbda/html/daag.asp
or
http://tinyurl.com/267s
Hope this helps.
Chris.
A
andrea catto'
from what I read...
SqlConnection is solely used against mssql servers...
whereas OldDBConnection in general uses any ODBC compliant driver
SqlConnection is solely used against mssql servers...
whereas OldDBConnection in general uses any ODBC compliant driver
C
cody
SqlConnection is solely used against mssql servers...
so what is OdbcConnection good for if OleDBConnection does the same work?
whereas OldDBConnection in general uses any ODBC compliant driver
so what is OdbcConnection good for if OleDBConnection does the same work?
W
William Ryan eMVP
Cody, you can use any of the three on SqlServer for instance, just as you
can use the OracleDB, OleDb or Odbc for Oracle.
Since the maturation of the technologies spanned quite a time frame, many
vendors provided support for multiple specs. In general, many suggest that
you use as specific a provider as possible if you want to take full
advantage of the DB features.
can use the OracleDB, OleDb or Odbc for Oracle.
Since the maturation of the technologies spanned quite a time frame, many
vendors provided support for multiple specs. In general, many suggest that
you use as specific a provider as possible if you want to take full
advantage of the DB features.
C
cody
Cody, you can use any of the three on SqlServer for instance, just as you
thank you!
can use the OracleDB, OleDb or Odbc for Oracle.
Since the maturation of the technologies spanned quite a time frame, many
vendors provided support for multiple specs. In general, many suggest that
you use as specific a provider as possible if you want to take full
advantage of the DB features.
thank you!
P
Paul Clement
¤ What is the difference between OleDBConnection and SqlConnection?
¤ Or better expressed, what is OleDB?
OLEDB is based upon COM (Component Object Model) so ultimately the code that executes is unmanaged
(interop). System.Data.OleDb is simply a .NET managed namespace (wrapper) for the COM OLEDB
providers.
AFAIK, the System.Data.SqlClient namespace is a fully native .NET managed provider and is
recommended if you are using SQL Server.
Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
¤ Or better expressed, what is OleDB?
OLEDB is based upon COM (Component Object Model) so ultimately the code that executes is unmanaged
(interop). System.Data.OleDb is simply a .NET managed namespace (wrapper) for the COM OLEDB
providers.
AFAIK, the System.Data.SqlClient namespace is a fully native .NET managed provider and is
recommended if you are using SQL Server.
Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)