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


Please Help Members By Posting Answers For Below Questions

How you will handle session when deploying application in more than a server?

581


What is the difference between system.stringbuilder and system.string

254


What are server side controls?

520


What is route in web api?

524


Define xmlreader class.

570






How does the service stream content?

581


By default, Web API sends HTTP response with which of the following status code for all uncaught exception?

965


Which is an advantage of application service providers?

485


In which situation can you not use a viewstate?

530


Which asp.net objects encapsulate the state of the client and the browser?

563


Why do we need master page in asp.net?

529


How to display Alert in ASP.NET

638


What is postback and autopostback in asp.net?

521


Can you explain one critical mapping?

516


Can any body provide me the sample web application in asp.net

1433