471,350 Members | 1,818 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,350 software developers and data experts.

SQLConnection vs OLEDbConnection

What is the difference when using SQLConnection and SQLX classes or
OleDbConection and OleDbXXX classes for database manipulation in
multiuser (e.g. 100 users) environment?

Can both handle connection pooling etc. or what might be the reason
when selecting from these two DB class categories?
Cheers!
Dec 28 '05 #1
1 3560
Greg,

If you are dealing with SQL Server, and you know you are, then you will
want to use the SQL classes. If you are dealing with another DB technology
that doesn't have a native provider, but an OLE DB provider, then use that.

IMO, you should only use the OLE DB provider when you have an OLE DB
provider for a database but no managed provider (like the classes in the
System.Data.SqlClient namespace).

Hope this helps.
--
- Nicholas Paldino [.NET/C# MVP]
- mv*@spam.guard.caspershouse.com

"Greg J" <gj@spam.mail.invalid.is> wrote in message
news:do**********@nyytiset.pp.htv.fi...
What is the difference when using SQLConnection and SQLX classes or
OleDbConection and OleDbXXX classes for database manipulation in
multiuser (e.g. 100 users) environment?

Can both handle connection pooling etc. or what might be the reason
when selecting from these two DB class categories?
Cheers!

Dec 28 '05 #2

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
4 posts views Thread by Curtis | last post: by
5 posts views Thread by Familjen Kalrsson | last post: by
2 posts views Thread by DaveL | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.