Consider you are developing a Windows-based application for tracking telephone calls. The application stores and retrieves data by using a Microsoft SQL Server database. You will use the SQL Client managed provider to connect and send commands to the database. You use integrated security to authenticate users. Your server is called TestKing30 and the database name is CustomerService. You need to set the connection string property of the SQL Connection object. Which code segment should you use?
Select Answer:
"Provider=SQLOLEDB.1;Data Source=TestKing30;Initial Catalog=CustomerService"
"Provider=MSDASQL;Data Source= TestKing30;Initial Catalog=CustomerService"
"Data Source= TestKing30;Initial Catalog=Master"
"Data Source= TestKing30;Initial Catalog=CustomerService"
|