Microsoft KB Archive/269594

= PRB: Error Message &quot;[Microsoft][ODBC driver for Oracle] Syntax error or access violation;37000&quot; =

Article ID: 269594

Article Last Modified on 5/12/2003

-

APPLIES TO


 * Microsoft Data Access Components 1.5
 * Microsoft Data Access Components 2.0
 * Microsoft Data Access Components 2.1
 * Microsoft Data Access Components 2.5
 * Microsoft Data Access Components 2.6
 * Microsoft Data Access Components 2.7
 * Microsoft Open Database Connectivity 2.5
 * Microsoft Open Database Connectivity 2.5
 * Microsoft Open Database Connectivity 2.5
 * Microsoft Open Database Connectivity 2.5
 * Microsoft Open Database Connectivity 2.5
 * Microsoft Open Database Connectivity 2.0

-



This article was previously published under Q269594



SYMPTOMS
Queries that contain more than 510 parameters may cause the following error messages to occur when you use the Microsoft ODBC driver for Oracle:

Relational data provider reported error: [Microsoft][ODBC driver for Oracle]Syntax error or access violation;37000

ODBC error(Error code -2147217900) : [Microsoft][ODBC driver for Oracle]Syntax error or access violation;37000



CAUSE
The Microsoft ODBC driver for Oracle has a limit of 510 parameters. If you try to use more than 510 parameters the error message occurs.



RESOLUTION
This problem does not occur when applications with such queries use the Microsoft OLEDB Provider for Oracle. You can use the Microsoft OLEDB Provider for Oracle as a workaround if you encounter this problem. The Microsoft OLEDB Provider for Oracle has a limit of 2001 parameters.



STATUS
This behavior is by design.

Additional query words: params lot many 37000

Keywords: kbnofix kboracle kbprb KB269594

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.