|A) Use a SqlConnection object to connect to the database, and use a SqlCommand object to run a stored procedure that returns the data.||B) Use an OleDbConnection object to connect to the database, and use an OleDbCommand object to run a stored procedure that returns the data.|
|C) Configure SQL Server to support HTTP access, and create an XML template to run a stored procedure that returns the data in XML format.||D) Use COM interop to create an ADODB.Connection object, and use an ADODB.Command object to run a SQL statement that returns the data.|
We need to use an OleDBConnection to connect to SQL Server Version 6.5 (or earlier).
A: We could use a SqlConnection object only if the SQL Server were SQL Server 7.0, 2000 or later.
C: HTTP functionality is not required in this scenario. It would introduce unnecessary overhead.
D: ADODB is a legacy standard and should not be used here