469,352 Members | 1,736 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,352 developers. It's quick & easy.

SQLConnection vs. OLEDbConnection

Which is preferred or what is the difference? SQLConnection or
OLEDbConnection.

We are connecting to data in MSSQL2000 primarily through stored procedures.
Nov 21 '05 #1
4 9446
"Curtis" <cu****@synergyontheweb.com> schrieb:
Which is preferred or what is the difference? SQLConnection or
OLEDbConnection.


You will more likely get an answer here:

<URL:news://news.microsoft.com/microsoft.public.dotnet.framework.adonet>

Web interface:

<URL:http://msdn.microsoft.com/newsgroups....dotnet.framew
ork.adonet>

--
Herfried K. Wagner [MVP]
<URL:http://dotnet.mvps.org/>
Nov 21 '05 #2
The classes in the SqlClient Namespace have been specifically designed to
work with SQL Server 7 and up. There's a whole extra in those classes
(SqlConnection, SqlCommand, etc) specific to SQL Server which you won't find
in the classes under the OLEDb namespace (OLEDbConnection, OLEDbCommand,
etc). Also, various optmizations have been built into these classes keeping
SQL Server in mind which cannot be in the more generic OLEDb classes. You
should use the classes in the SqlClient namespace unless you have a good
reason not to. So I would suggest using SqlConnection for SQL Server 2000
and also using the remaining classes in the SqlClient namespace for data
access.
hope that helps..
Imran.

"Curtis" <cu****@synergyontheweb.com> wrote in message
news:%2****************@TK2MSFTNGP09.phx.gbl...
Which is preferred or what is the difference? SQLConnection or
OLEDbConnection.

We are connecting to data in MSSQL2000 primarily through stored
procedures.

Nov 21 '05 #3
hi.. I have recently just completed a project using entirely sqlxxx ado.net
command set ... however one customer has some Win98 system and sqlxxx
commands don't work .. have to take great pain to change all to OLEDBxxxx
...(not aware of any documentation mentioned about this....or i could have not
dig deep enough to find them..)
so my very own conclusion is SQLxxx is faster but OLEDBxxx is safer for
compatibility....

Albert

"Curtis" wrote:
Which is preferred or what is the difference? SQLConnection or
OLEDbConnection.

We are connecting to data in MSSQL2000 primarily through stored procedures.

Nov 21 '05 #4
Windows 98 is a supported platform for the classes in the SqlClient
namespace. Lookup the documentation for any of the classes and you should
see that. AFAIK, you need to make some changes with the Sql Server
configuration (or rather MSDE configuration since I don't think Sql Server
2000 runs on Windows 98) so as to get it to work correctly. Apart from that,
the classes should work fine.

hope that helps..
Imran.
"Albert" <Al****@discussions.microsoft.com> wrote in message
news:96**********************************@microsof t.com...
hi.. I have recently just completed a project using entirely sqlxxx
ado.net
command set ... however one customer has some Win98 system and sqlxxx
commands don't work .. have to take great pain to change all to OLEDBxxxx
..(not aware of any documentation mentioned about this....or i could have
not
dig deep enough to find them..)
so my very own conclusion is SQLxxx is faster but OLEDBxxx is safer for
compatibility....

Albert

"Curtis" wrote:
Which is preferred or what is the difference? SQLConnection or
OLEDbConnection.

We are connecting to data in MSSQL2000 primarily through stored
procedures.

Nov 21 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Tom Hartnett | last post: by
3 posts views Thread by Stephen | last post: by
3 posts views Thread by Ludvig | last post: by
5 posts views Thread by Familjen Kalrsson | last post: by
2 posts views Thread by DaveL | last post: by
1 post views Thread by CARIGAR | last post: by
1 post views Thread by Marylou17 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.