Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

BUG: "No Result" Error Saving Oracle Parameterized View


View products that this article applies to.

This article was previously published under Q187788

↑ Back to the top


Symptoms

After creating a parameterized remote view to an Oracle 8.0 table using the Oracle 8.0 ODBC driver, the following error occurs when you try to save the remote view:
No result set has been returned by the server.
The remote view runs while in design mode, but saving the remote view causes the error to occur. This error does not occur when using the Microsoft Oracle ODBC driver.

↑ Back to the top


Resolution

Use the Microsoft Oracle ODBC driver. Please see the article listed in the REFERENCES section for information on obtaining the Microsoft Oracle ODBC driver.

↑ Back to the top


Status

Microsoft has confirmed this to be an incompatibility with the ODBC driver from Oracle and the Microsoft products listed at the beginning of this article.

↑ Back to the top


More information

Steps to Reproduce Behavior

  1. Create a remote view using an Oracle 8.0 ODBC driver that uses an Oracle table.
  2. In the Open dialog box, select a table.
  3. Click the Fields tab and select some fields. From the Query, choose "View Parameters".
  4. In the View Parameters dialog box, type "xyz" (without the quotes) in the Name text box. In the Type box, type or select a field type to match a field in the table. Press OK to exit the View Parameters dialog box.
  5. In the View Designer dialog box, click the Filter tab. In the Field Name box, select a field with the same data type as the variable "xyz" created in step 4. Type "?xyz" (without the quotes) in the Example text box.
  6. Run the remote view and type something into the View Parameters dialog box. Note that the remote view returns data if it find a matching record.
  7. Save the remote view and note that the error occurs. There is no way to save the remote view unless you remove the parameter statement from the View Parameters dialog box.

↑ Back to the top


References

For information on obtaining the Microsoft Oracle ODBC driver, please see the following article in the Microsoft Knowledge Base:
175018� HOWTO: Acquire and Install the Microsoft Oracle ODBC Driver

↑ Back to the top


Keywords: KB187788, kbnofix, kbbug

↑ Back to the top

Article Info
Article ID : 187788
Revision : 2
Created on : 10/16/2002
Published on : 10/16/2002
Exists online : False
Views : 486