Steps to Reproduce the Behavior

1. Start Microsoft Visual Studio .NET, and then create a new Visual Basic Console application. Module1 and a reference to the System.Data namespace are added by default.
2. Add the following Imports statements to the top of Module1's Code window:

   Imports System
   Imports System.Data.OleDb
   					

3. Paste the following code into the Sub Main procedure:

   Dim cn As OleDbConnection = New OleDbConnection("Provider=SQLOLEDB;Data Source=servername;" & _
                                                   "User ID=login;Password=password;" & _
                                                   "Initial Catalog=Northwind;")
   cn.Open()
   
   'Specify that no records be returned.
   Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM Customers WHERE 1=0", cn)
   
   Dim dr As OleDbDataReader
   Try
         dr = cmd.ExecuteReader(CommandBehavior.SingleRow)
         'WORKAROUND: Comment out the above line, and uncomment the following line.
         'dr = cmd.ExecuteReader()
   
         Console.WriteLine("ExecuteReader is executed")
         dr.Close()
   Catch ex As Exception
         Console.WriteLine(ex.Message.ToString())
   Finally
         'Pause.
         Console.ReadLine()
         'Clean up.
         cn.Close()
   End Try
   					

4. Modify the connection string to connect to the computer that is running SQL Server.
5. Press F5 to build and to start the project. You receive an error message. Press ENTER to return to the development environment.
6. To work around this problem, comment out the following line

         dr = cmd.ExecuteReader(CommandBehavior.SingleRow)
   						

   and uncomment the following line:

         'dr = cmd.ExecuteReader()
   					

7. Press F5 to rebuild and start the project. Notice that the ExecuteReader method succeeds. Press ENTER to return to the Development Environment.

Back to the top