GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Microsoft  >  ADO.NET 2.0
Go To First  |  Previous Question  |  Next Question 
 ADO.NET 2.0  |  Question 9 of 19    Print  
Differences between OLEDB SQL SERVER , OLEDBDOTNET PROVIDER ?

  
Total Answers and Comments: 2 Last Update: April 18, 2008   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
April 14, 2006 22:21:25   #1  
Ashish Misra        

RE: Differences between OLEDB SQL SERVER , OLEDBDOTNET...
OleDBDotNet Provider can be used to connect to any DataSource but OleDb SQL SERVER can be used to connect only to a SQL Server DataSource.
 
Is this answer useful? Yes | No
April 18, 2008 02:46:58   #2  
ynvpavan Member Since: September 2007   Contribution: 16    

RE: Differences between OLEDB SQL SERVER , OLEDBDOTNET PROVIDER ?

u just have a look over the fig 2 in this link and u can get somne info i think...


http://msdn2.microsoft.com/en-us/magazine/cc163933.aspx


And also the OLEDBSQL Provider posses native drivers to interact with database and the oledb had it's own drivers.
As compared OLEDBsql driver is more efficient to use for the fastness.


 
Is this answer useful? Yes | No

 Related Questions

Latest Answer : SqlConnectionSqlcommandSqlDataReaderSqlDataAdapterDataSet ...
Read Answers (5) | Asked by : shruthi

Latest Answer : u just have a look over the fig 2 in this link and u can get somne info, i think...http://msdn2.microsoft.com/en-us/magazine/cc163933.aspxAnd also, the OLEDBSQL Provider posses native drivers to interact with database and the oledb had it's own drivers.As ...

Latest Answer : 1. Ado.net 2.0 provides MARS ( multiple active resultsets which allows you to have two datareader on one connection open at sametime.2. Ado.net 2.0 provide bulk copy facility.3. Ado.net 2.0 provides table adapters and hence allows easy to create DAL.There ...
Read Answers (2) | Asked by : maneesha

Latest Answer : One more thing...Server.Transfer supports only ASPX pages but Response.Redirect applies even HTML pages ...
Read Answers (3) | Asked by : sambit

Imports System.Data.SqlClientPublic Class Form1Dim cn As New SqlConnection("server=.;database=atten;uid=sa;pwd=sa;")Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) 
Latest Answer : Column Name do not allow numeric values.choose Charecters. ...


 Sponsored Links

 
Related Articles

SQL Server 2005 Integration Services Review

SQL Server 2005 Integration Services using Visual Studio 2005 A Beginner s Guide SQL Server 2005 A offering of Microsoft Corporation for database management the SQL server 2005 is one of the powerful database management systems in the world Available for integration in almost any system that uses Mi
 

SQL Server Integration Services

SQL Server Integration Services Here is a sample chapter from Beginners Guide to SQL Server Integration Services Using Visual Studio 2005 by Jayaram Krishnaswamy Environment set up for Visual Studio 2005 with respect to SSIS and multiple tasking Connecting to Microsoft Access Text Files Excel S
 

Web Server

Web Server A web server can be a program or the computer itself which receives the requests from various other browsers and responds to those requests These requests are all requests that are being sent for some documents There are two kinds of web servers available The web server program and the
 

Client-Server Models and N-Tier Applications

Client Server Models and N Tier Applications One of principal objective of Client Server methods is to provide data to an end user However Client Server architectural methodologies are much more complex Client Server describes the process wherein a client program generates contact with a separate se
 

Java and Client Server Models

Java and Client Server Models The Role of Client Servers on the Web Client server models provide the essential mechanisms for working with the Internet In fact most of the World Wide Web is built according to this paradigm In client server models the web browsers run by millions of users are the cli
 

Web Services and Client Server Technology

Web Services and Client Server Technology Introduction to Distributed Computing The Internet and expanded network connectivity established client sever models as the preferred form of distributed computing When talking about Client Server models of networked communication using web services the broa
 

Object-Oriented Client-Server Internet

Object Oriented Client Server Internet OCSI Environments as IT Infrastructure Client Server Basics Object Oriented Client Server Internet OCSI environments provide the IT infrastructure for supporting OCSI applications For our purposes infrastructure refers to operating systems networks middleware
 

N-Tier Client-Server Architecture

N Tier Client Server Architecture Description of 1 Tier and 2 Tier Web Applications This article will discuss the various architectures of Client Server environments Perhaps the most influential Client Server environment is the Internet and its global users With the increasing use of web application
 

What are the differences between stored procedures and triggers?

Stored procedures are compiled collection of programs or SQL statements that live in the database. A stored procedure can access and modify data present in many tables. Also a stored procedure is not associated with any particular database object. But triggers are event-driven special procedures whi
 

Language Enhancements in SQL Server 2005

The T-SQL has been enhanced to include error handling, recursive query and to support the new database engine capabilities. Two new relational operators have been introduced—PIVOT and UNPIVOT for use in the FORM clause query. They perform manipulation on an input table valued expression an
 

About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape