1.

You are a Web developer for XYZ. You create an ASP.NET application that accesses sales and marketing data. The data is stored in a Microsoft SQL Server 2000 database on a server named XYZ01._x005F_x000D_ The company purchases a factory automation software application. The application is installed on XYZ01, where it creates a second instance of SQL Server 2000 named Factory and a database named FactoryDB. You connect to FactoryDB by using Windows Integrated authentication._x005F_x000D_ You want to add a page to your ASP.NET application to display inventory data from  FactoryDB. You use a SqlConnection object to connect to the database. You need to create a connection string to FactoryDB in the instance of SQL Server named Factory on XYZ01. Which string should you use?

A. ?Server=XYZ01;Data Source=Factory; Initial Catalog=FactoryDB;Integrated Security=SSPI?
B. ?Server=XYZ01;Data Source=Factory; Database=FactoryDB;Integrated Security=SSP1?
C. ?Data Source=XYZ01\Factory; Initial Category=Factory; Integrated Security=SSP1?
D. ?Data Source=XYZ01\Factory; Database=FactoryDB; Integrated Security=SSP1?
Answer» E.


Discussion

No Comment Found

Related MCQs