BUG: SQLOLEDB May Fail with Parameterized Queries

View products that this article applies to.

This article was previously published under Q304372

Symptoms

When you use the ICommandPrepare::Prepare() call to prepare a SQL query containing parameter markers, union clause, and a query "hint", the following error may be received:

Incorrect syntax near the keyword <WITH or any token>

The following is an example of such a SQL query:

SELECT EmployeeID,LastName from Employees WITH (NOLOCK) where EmployeeID > ? 
UNION
SELECT EmployeeID, LastName from Employees WITH (NOLOCK)

↑ Back to the top

Cause

There is a bug with parsing table names when trying to retrieve information on parameters.

↑ Back to the top

Resolution

To work around this problem, set the parameter information with the call to ICommandWithParameters::SetParameterInfo before preparing the statement with ICommandPrepare::Prepare.

↑ Back to the top