The information in this article applies to:
SYMPTOMSThe Microsoft Oracle Driver parses the string contents of the WHERE clause for SQL keywords. For example:
Some SQL keywords generate different errors. The SQL keywords must be
followed by a space to cause the problem. The sample provided later shows
the problem with the FOR and SELECT keywords. The problem is case
insensitive and the ORDER and GROUP keywords also cause the same problem.
STATUSThis has been fixed in the 2.573.2927 version of the Microsoft Oracle ODBC driver. The driver is available in Visual Studio 6.0 and Microsoft Data Access Components version 2.0. The current MDAC components can be downloaded at from the following Web address: http://www.microsoft.com/data/ MORE INFORMATIONSteps to Reproduce Behavior in ODBCTestFirst, create the table:
Return: SQL_NO_DATA_FOUND=100 To show that that steps above work, use the following SQL Statement:
Change the WHERE clause string to (this works):
Follow steps 4 through 7. No Error, and data is returned.
To show that different KEYWORDS are effecting the query try the following:
Change the WHERE clause to:
Follow steps 4 through 7. Now the error occurs on the SQLPrepare:
Additional query words: kbodbc kbdatabase kboracle kbdriver kbdse kbDSupport
Keywords : kbVBp600fix kbODBC200bug kbODBC250 kbGrpMDAC kbGrpODBC |
Last Reviewed: December 23, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |