Karthick P.K on SQL Server

Posts Tagged ‘Oracle linked server Access violation exception’

SQL Server generated Access Violation dumps while accessing oracle linked servers.

Posted by Karthick P.K on August 8, 2012


When you run queries against Oracle linked servers from SQL Server you see errors like one below and access violation dumps are generated (SQLDump00XX.mdmp files in SQL Server error log folder).


External dump process returned no errors.
Using ‘dbghelp.dll’ version ‘4.0.5’
SqlDumpExceptionHandler: Process 510 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process.
* *******************************************************************************
*  Exception Address = 000000007752485C Module(ntdll+000000000002285C)

*   Exception Code    = c0000005 EXCEPTION_ACCESS_VIOLATION

*   Access Violation occurred reading address 0000041EA9AE2EF0

* Input Buffer 510 bytes –



To analyze the dump download and Install Windows Debugger from This  link

1. Open Windbg

2. Choose File menu –> select Open crash dump –>Select the Dump file

3. on command window type    
.sympath srv*c:\Websymbols*;

4. Type .reload /f and hit enter. This will force debugger to immediately
load all the symbols.

5. Type .ecxr

6. Type  kL    and look at the stack





If you see above frames in the top of the stack and if you are using Oracle Provider for OLE DB – Version: and later.

There is a known issue with Oracle Provider for OLE DB – Version: and later   when  — STYLE COMMENTS are used in linked server queries ,SP’s Etc .


1. Remove the – -style comments
2) use /* */ for the comments instead of —


If you liked this post, do like us on FaceBook at and join our FaceBook group!/groups/454762937884205/



Karthick P.K

Posted in Connectivity, Debugging, SQL Server Engine | Tagged: , , , , | 4 Comments »

%d bloggers like this: