Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. PRB: Error Message "[Microsoft][ODBC driver for Oracle] Syntax error or access violation;37000"

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

View products that this article applies to.

This article was previously published under Q269594

↑ Back to the top

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

↑ Back to the top

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.

↑ Back to the top

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.

↑ Back to the top

Status

This behavior is by design.

↑ Back to the top

Keywords: kbnofix, kboracle, kbprb, KB269594

↑ Back to the top

Article Info
Article ID : 269594
Revision : 3
Created on : 5/12/2003
Published on : 5/12/2003
Exists online : False
Views : 438