Question: You are writing the code for a Web application that will access data in a Microsoft SQL Server database. Which of the following connection string's

You are writing the code for a Web application that will access data in a Microsoft SQL Server database. Which of the following connection string's codes can you use assuming that the database file is called transactions.mdf?
Question 5 options:
a)
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\transactions.mdf;
User ID=; Password=;
b)
Provider=Microsoft.DB2OLEDB.12.0;Data Source=C:\transactions.mdf;
User ID=; Password=;
c)
Provider=SQLOLEDB;Data Source=C:\transactions.mdf;
User ID=; Password=;
d)
Provider=MySQLProv;Data Source=C:\transactions.mdf;
User ID=; Password=;

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!