Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

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.
0
LegalIT
Asked:
LegalIT
  • 3
  • 2
1 Solution
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
As I recall, ODBC is older and slower.  OLEDB is best.
0
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
0
 
rohanbairat3Commented:
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...

-rons
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
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 ?

Regards
0
 
rohanbairat3Commented:
yes. thats correct.

-rohan
0
 
rohanbairat3Commented:
Do you need any more information ? Did I answer your question ?

Please close the question if you have the answer.

Thanks

-Rons
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now