Oledb and ODBC, which one is good for connecting to SQL Server?

Dear all experts,

  I'm going to do a VB.Net project which is used to retreive data from SQL Server 2000, before I go ahead, I would like to know which connection methods is better.  Or apart from them, is there any connection method?

Thanks in advance.
Who is Participating?
If you are using SQL Server u might aswell go with SQL conenctions ...SqlConnection , SqlDataReader, SqlCommand..they work onh SQL server only ...with OLEDB u can connect to diff databases ...but using SQLConnection can give u some bosst in performance...

Lee W, MVPTechnology and Business Process AdvisorCommented:
As I recall, ODBC is older and slower.  OLEDB is best.
Lee W, MVPTechnology and Business Process AdvisorCommented:
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

LegalITAuthor Commented:
Dear rons,

  that mean for my case (vb.net to SQL 2K), I should use SQL Client provider rather than OLEDB provider?  How about after SQL 2005 release?  Still the same ?

yes. thats correct.

Do you need any more information ? Did I answer your question ?

Please close the question if you have the answer.


Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.