70 305 Total Questions 212 Page 10 of 144 We specify the name of the SQL Server

70 305 total questions 212 page 10 of 144 we specify

This preview shows page 10 - 12 out of 144 pages.

70-305 Total Questions: 212 Page 10 of 144 We specify the name of the SQL Server computer with the Data Source attribute. The database is specified with the Initial Catalog attribute. Reference: .NET Framework Class Library, SqlConnection.ConnectionString Property [Visual Basic] Incorrect Answers A, B: The SqlConnection.ConnectionString has no Provider attribute. The provider is implicitly SQL Server 7.0 or later. D: There is no Initial File name attribute in the SqlConnection.ConnectionString. This attribute makes the connection string invalid. Question: 14. You are using ASP.NET and ADO.NET to create an accounting application for XYZ. You are writing code to run a set of stored procedures that perform posting operations in a database at the end of each month. You use an OleDbConnection object to connect to the database. You use an OleDbCommand object to run the stored procedures. If an error occurs during execution of any of the stored procedures, you want to roll back any data changes that were posted. You want the changes to be committed only of all of the posting operations succeed. You write code to catch an OleDbException object if an error occurs during the execution of a stored procedure. What else should you do? Reference: .NET Framework Class Library, OleDbConnection.BeginTransaction Method [Visual Basic] .NET Framework Class Library, OleDbCommand.Transaction Property [Visual Basic]
Image of page 10
Exam Name: Developing and Implementing Web Applications with Microsoft Visual Basic.NET Exam Type: Microsoft Exam Code: 70-305 Total Questions: 212 Page 11 of 144 Incorrect Answers A, B: We must create an OleDbTransaction object for the transaction.
Image of page 11
Image of page 12

You've reached the end of your free preview.

Want to read all 144 pages?

  • Spring '16
  • .NET Framework, Microsoft SQL Server, Microsoft Visual Studio

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture