OLEDB vs SQLClient

View: New views
2 Messages — Rating Filter:   Alert me  

OLEDB vs SQLClient

by Boudreau, Duane :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Which is better? Is there a difference? I've heard conflicting stories. I've heard that they are essentially the same thing, but during a recent ASP.Net 2.0 class the instructor said that it was more efficient to us the SQLClient interface as it was MS's native driver.
 
Any idea which if any is better?
 
Thanks,
Duane


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Discover CFTicket - The leading ColdFusion Help Desk and Trouble
Ticket application

http://www.houseoffusion.com/banners/view.cfm?bannerid=48

Message: http://www.houseoffusion.com/lists.cfm/link=i:44:1625
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/44
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:44
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.44
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

Re: OLEDB vs SQLClient

by Nathan Strutz :: Rate this Message:

Reply to Author | View Threaded | Show Only this Message

Generally speaking, ODBC is knocking at death's door. Its old protocols
are useful now only for connecting to a database your platform doesn't
know how to talk with directly, such as MS Access.

If you have a choice, you 100% want to use the SQLClient drivers to talk
to a SQL Server.

-nathan strutz


Boudreau, Duane wrote:
> Which is better? Is there a difference? I've heard conflicting stories. I've heard that they are essentially the same thing, but during a recent ASP.Net 2.0 class the instructor said that it was more efficient to us the SQLClient interface as it was MS's native driver.
>  
> Any idea which if any is better?
>  
> Thanks,
> Duane
>
>
>

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Find out how CFTicket can increase your company's customer support
efficiency by 100%
http://www.houseoffusion.com/banners/view.cfm?bannerid=49

Message: http://www.houseoffusion.com/lists.cfm/link=i:44:1626
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/44
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:44
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=17837.14401.44
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54