nerdexam
Microsoft

98-361 · Question #370

You are developing a C# program for a bike rental company. The data is stored in a SQL Server 2000 server named BikeServer in a database named BikeDB. You must use the Windows Integrated…

The correct answer is A. "Provider=SQLOLEDB; Data Source=BikeServer; InitialCatalog=BikeDB. See the full explanation below for the reasoning.

Question

You are developing a C# program for a bike rental company. The data is stored in a SQL Server 2000 server named BikeServer in a database named BikeDB. You must use the Windows Integrated authentication to connect to the BikeDB database. Which of the following connection strings should you choose in your C# program for connecting to the BikeDB database?

Options

  • A"Provider=SQLOLEDB; Data Source=BikeServer; InitialCatalog=BikeDB;
  • B"Provider=SQLOLEDB; Data Source=BikeServer; InitialCatalog=BikeDB;
  • C"Data Source=BikeServer; InitialCatalog=BikeDB;
  • D"Data Source=BikeServer; InitialCatalog=BikeDB;

How the community answered

(27 responses)
  • A
    78% (21)
  • B
    15% (4)
  • C
    4% (1)
  • D
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 98-361 Practice