PRB: Error Message "[Microsoft][ODBC driver for Oracle] Syntax error or access violation;37000" (269594)


The information in this article 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 ODBC for Oracle version 2.5 Build 2.573.2927
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.3711
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.4403
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.6526
  • Microsoft ODBC for Oracle version 2.5 Build 2.573.7713.2
  • Microsoft ODBC for Oracle version 2.0 Build 2.73.7269
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.
Modification Type:MajorLast Reviewed:5/12/2003
Keywords:kbnofix kbOracle kbprb KB269594
©2002 Microsoft Corporation. All rights reserved.