PRB: Can't Read Temporary Table Created Using # Sign in RDO

MORE INFORMATION

Steps to Reproduce Behavior

1. Start a new project in Visual Basic. Form1 is created by default.
2. Add a CommandButton, Command1 to Form1.
3. Paste the following code into the General Declarations section of Form1:

            Private Sub Command1_Click()
   
         Dim rdoEnv As rdoEnvironment
         Dim rdoConn As rdoConnection
         Dim strConn As String
         Dim ps As rdoPreparedStatement
   
         Set rdoEnv = rdoEngine.rdoEnvironments(0)
            rdoEnv.CursorDriver = rdUseOdbc
   
            '***You need to change the SERVER, UID, and PWD parameters here.
         strConn = "driver={SQL Server};server=myserver;" & _
         "database=pubs;uid=<username>;pwd=<strong password>"
            Set rdoConn = rdoEnv.OpenConnection( _
              dsName:="", _
              Prompt:=rdDriverNoPrompt, _
              ReadOnly:=False, _
              Connect:=strConn)
   
         rdoConn.Execute "Select * into #Temp1 From Authors"
              Set rs = rdoConn.OpenResultset("Select * from #Temp1")
              Do Until rs.EOF
                 Debug.Print rs.rdoColumns(0) & ", " & rs.rdoColumns(1)
                 rs.MoveNext
              Loop
              rs.Close
              rdoConn.Close
              rdoEnv.Close
   
            End Sub
   						

4. Youmust change UID =<username> and PWD =<strong password> to the correct values before you run this code. Make sure you have an appropriate ODBC data source and that UID has the appropriate permissions to perform this operation on the database. Start the program by pressing the F5 key.
5. Click the Command1 button to execute the code. You will receive the following error message indicating that table #Temp1 in SQL server cannot be found:
   Run-time Error '400002':
   S0002: [Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name
   '#Temp1'.