BUG: Data View: New Oracle Views Incorrectly Named During Save (196587)

MORE INFORMATION

Steps to Reproduce Behavior

1. Start Visual Basic 6.0 and create a Standard EXE project.
2. From the Project menu, choose Add Data Environment.
3. Right-click Connection1 and choose Properties. In the Data Link Properties dialog box, click the Connection tab. In step 1, select "Use connection string" and enter a valid Server name, UserID, and Password to your Oracle Data Source in the Connection string text box. Here is an example of a connection string:

         Server: dseOracle
                 UserID: Scott
                 Password: Tiger
   
   						

   After you enter the connection sting, click OK.
4. From the View menu choose "Data View Window". Click the "+" next to the folder labeled "Connection1" to expand the folder. When the folder expands, right-click the folder named "View", and then select New View.
5. In the space provided enter a valid SQL statement, such as the following:

         SELECT *
         FROM EMPLOYEES
   
   						

6. Click the Close button in the top right corner of the form. When prompted to save, click Yes. Save the view, name it vEmp and then click OK.
7. Open the DataEnvironment. In the Project1 DataEnvironment dialog box, right-click Connection1 and choose Add Command.
8. Right-click Command1 to open the Command1 Properties dialog box. In the Command1 Properties dialog box, click the General tab. Select the Database Object option button, click the down arrow of the text box and then select View.
9. Click the drop-down arrow of the Object Name textbox, select vEmp or <uid>.vEmp, and then click OK.
10. From the Project menu, choose Components and select the Microsoft Datagrid Control 6.0 (OLEDB). Next, place a Datagrid and a Command button on the form.
11. Enter the following code into the Click event of the Command button:

          Set DataGrid1.DataSource = DataEnvironment1
          DataEnvironment1.Commands("Command1").CommandText = "vEmp"
          DataEnvironment1.Command1
          DataGrid1.DataMember = "Command1"
          DataGrid1.Refresh
    
    						

12. Run the project and click the Command1 command button.
    
    RESULT: The following error occurs:
    Run-time error '-2147217865 (80040e37)': ORA-00942: table or view does not exist.
    This error also appears if the view is executed in SQL Plus.