Symptoms

Consider the following scenario:

  • You have a SQL Server Native Client OLE DB provider application that connects to a server that is running Microsoft SQL Server 2012 or SQL Server 2014 to access data.

  • The application calls the Prepare method on an instance of SQL Server to prepare queries to use parameters.


In this scenario, a memory leak condition may occur.

Each new cumulative update for SQL Server contains all the hotfixes and all the security fixes that were included with the previous cumulative update. Check out the latest cumulative updates for SQL Server:


Workaround

To work around this problem, add the DataTypeCompatibility=80 keyword to the Connection String for the SQL Server.

For more information, see Data Type Compatibility for Client Versions in the following topic on the Microsoft TechNet website:

System Requirements for SQL Server Native Client

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

References

See the terminology Microsoft uses to describe software updates.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×