The information in this article applies to:
SYMPTOMSWhen you try to use table aliases in SELECT statements with the Microsoft Oracle ODBC driver and you are using the Keyset cursor type, you receive the following error:
CAUSE
When the driver re-writes the SQL statement to send to the Oracle server it
doesn't create the correct syntax.
In turn, The Microsoft Oracle ODBC driver maps that error message to the message listed in the SYMPTOMS section of this article. RESOLUTIONThe solution depends on the nature of the application. If the application needs to use Keyset cursors, it may not use table aliases. If the application must use table aliases, the cursor type must be changed to FORWARD-ONLY or STATIC. STATUSMicrosoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. We are researching this bug and will post new information here in the Microsoft Knowledge Base as it becomes available. MORE INFORMATIONSteps to Reproduce Behavior using ODBCTest
Additional query words: kbDSupport kbOracle kbDatabase kbODBC kbDriver odbcOracle
Keywords : odbcOracle |
Last Reviewed: August 24, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |