FIX: You may receive an access violation error message when the application uses the SQLOLEDB provider

View products that this article applies to.

SYMPTOMS

Your application uses Microsoft OLE DB Provider for SQL Server (SQLOLEDB). When the SQLOLEDB provider uses the Sqlxmlx.dll file for doing transformation between Transact-SQL commands and XML commands, you may receive an access violation error message.

Back to the top

CAUSE

The access violation occurs in the SQLOLEDB provider because the SQLOLEDB provider tries to dereference an unloaded Sqlxmlx.dll file. The Sqlxmlx.dll file unloads unexpectedly because the Sqlxmlx.dll file contains an incorrect global object count.

Back to the top

RESOLUTION

To resolve this problem, obtain the latest service pack for Microsoft Windows XP. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

322389 (http://support.microsoft.com/kb/322389/ ) How to obtain the latest Windows XP service pack

To resolve this problem, you can also obtain the hotfix that is mentioned in the following Microsoft Knowledge Base article:

838976 (http://support.microsoft.com/kb/838976/ ) FIX: SQLOLEDB stops responding when the sqlxmlx.dll file unloads unexpectedly

Note The hotfix that is mentioned in this article can be used to resolve this problem even if this problem occurs on a computer that is not running Microsoft Windows XP.

Back to the top

STATUS

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

Back to the top

MORE INFORMATION

When you access the data from a browser and the URL contains XML commands, the Sqlxmlx.dll file translates the XML commands of the URL to Transact-SQL commands. SQL Server 2000I uses the Transact-SQL commands to retrieve the database records, and the Sqlxmlx.dll file formats the database records into an XML document.

Back to the top

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

824684 (http://support.microsoft.com/kb/824684/ ) Description of the standard terminology that is used to describe Microsoft software updates

For more information, visit the following Microsoft Developer Network (MSDN) Web sites:

Installing the OLE DB Provider for SQL Serverhttp://msdn2.microsoft.com/en-us/library/aa198252(SQL.80).aspx (http://msdn2.microsoft.com/en-us/library/aa198252(SQL.80).aspx)

Hands-on XMLhttp://msdn2.microsoft.com/en-us/library/aa496019(SQL.80).aspx (http://msdn2.microsoft.com/en-us/library/aa496019(SQL.80).aspx)

Back to the top