PRB: DELETE Without FROM Clause Causes Errors in Oracle Driver

• Microsoft ODBC for Oracle (Build 2.73.7269), version 2.0
• Microsoft ODBC for Oracle (Build 2.73.7283.03), version 2.0

SYMPTOMS

When you attempt to use the SQL DELETE statement without a FROM clause, you will receive the following error message:

[Microsoft][ODBC driver for Oracle]Syntax error or access violation

RESOLUTION

If you are using the 2.0 drivers the FROM clause must be used in the DELETE statement in order to delete records from the table. Using the 2.5 Oracle ODBC driver corrects this problem. You can obtain the 2.5 driver with Visual Studio 6.0, Data Access Data Access Software Development Kit (SDK) 2.0, or Microsoft Data Access Components (MDAC) 2.0. You can download the latest MDAC components from the following Web address:

http:\\www.microsoft.com\data\

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. The Microsoft Oracle ODBC driver version 2.5 (Build 2.573.2927) corrects this problem.

Additional query words: kbDSupport kbODBC kbOracle kbDriver

Keywords : kbODBC200 kbGrpMDAC kbGrpODBC
Version : WINDOWS:2.0
Platform : WINDOWS
Issue type : kbprb