When would you not use the oleDbConnection object?
a) To connect to an SQL 7.0 database.
b) To connect to a DB/2 database.
c) To connect to an Access database.
d) To connect to an SQL 6.5 database.
Answer Posted / bhushan
Guyz...The question is "When would you....?". IMO, we can
connect to any database using oleDbConnection. However, the
question dwells on the fact that when would we not use it.
The fact that MS Access is a desktop database, leaves us no
option but to use oleDbConnection. Also, there must be some
way to connect to DB/2 database. The only 2 choices are to
use ODBC and OLEDB. So that has to be used with DB/2 as
well. However, with SQL server databases we have plenty of
support by the way of Sqlconnection and associated data
objects. These objects make it easier to work with SQL
databases easier than to use raw oleDbconnection. So the
obvious choice would amongst these 2. Yet going further, we
would refine our answer and state that support for SQL 7.0
has improved over SQL 6.5 and hence it has all the more
reason so as not to use OLEDBConnection. So IMO, the answer
should be SQL 7.0 database. Please correct me if any one
knows better...
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is IPostBack? How to use it?
What are the best practices to follow to secure connection strings in an ASP.NET web application?
How do we sort the data from a dataset?
what are the ihttphandler and ihttphandlerfactory interfaces ?
Whta are the Various steps taken to optimize a web based application (caching, stored procedure etc.) ?
Explain the use of errorprovider control in .net?
Can you use Web API with ASP.NET Web Form?
Disable browser cache for entire ASP.NET website?
How to disable disable browser's Back button in asp.net (JavaScript)?
What is the recommended approach for asp.net mvc to globally intercept exceptions? What other functionality can be implemented with the approach? : Asp.Net MVC
What is session object? Describe in detail.
What are the types of caching in asp.net?
Explain some of the major built-in objects in asp.net
Suppose You Want A Certain Asp.net Function Executed On Mouseover For A Certain Button. Where Do You Add An Event Handler?
What is the concept of postback in asp.net?