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.
- 6 Answers
- 8965 Views
- Syntax Softtech, I also Faced
- E-Mail Answers
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 the difference between client-side and server-side validations in ASP.NET?
Which methods validate all the controls on a page?
What are different types of authentication techniques that are used in connection strings to connect .net applications with microsoft sql server?
How to find out what version of asp.net I am using on my machine?
What is the default Orientation property in a Menu control?
How does session work in asp net?
How many ways are there to maintain a state in .net? What is view state?
What is a postback ispostback and autopostback in asp net?
What is custom attribute?
What is web configuration file and how to use in web application
What are strong names?
How do you secure your configuration files to be accessed remotely by unauthorized users?
What can you do with asp.net?
Describe a Windows Service and its lifecycle ?
What is fulltrust?
