7.0.1000.4 Access Violation Exception in db code

[NinjaTrader_RyanM1]

Hi nailz420,

Thanks for reply. Can you please send your latest trace files to support 'at' ninjatrader 'dot' com the next time you see this occur?

[nailz420]

This closed issue in the SQLCE 3.5 SP2 seems to be exactly what's causing the market replay crash and the conditions are also comparable

https://connect.microsoft.com/SQLServer/feedback/details/652064/sqlce-3-5-sp2-nullreferenceexception-from-system-data-sqlserverce-accessor-dispose

It seems to have been fixed by Cummulative Update 2 (6 is the latest)

you can also refer to this post on stackoverflow for more info:

http://stackoverflow.com/questions/5342303/sqlce-3-5-sp2-nullreferenceexception-from-system-data-sqlserverce-accessor-dispo

[ATX_tdr]

I get the same exception randomly under normal operating conditions

So, I see this is considered solved. I get these crashes occasionally on NT 7.0.1000.9.
and I get stack traces like this in the trace file:

2012-12-13 12:46:00:537 in OnUnhandledApplicationException
2012-12-13 12:46:00:580 *************** unhandled exception trapped ***************
2012-12-13 12:46:00:580 Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
2012-12-13 12:46:00:580 System.AccessViolationException: Attempted to read or write protected memory. This is often an indication that other memory is corrupt.
   at System.Data.SqlServerCe.NativeMethods.CoTaskMemFree(IntPtr ptr)
   at System.Data.SqlServerCe.Accessor.Dispose()
   at System.Data.SqlServerCe.Accessor.Finalize()

So, I did a little digging. It appears that I have SQL CE 3.5 SP2 installed with the System.Data.SqlServerCE.dll registed in the GAC (I have Visual Studio 2010 installed) version 3.5.8080.

I see in the NinjaTrader install directory that version 3.5.8085 of System.Data.SqlServerCE.dll is distributed with the application.

It appears when I run NinjaTrader and inspect what dll's are loaded using Process Explorer (Systernals) I find that NT is pulling the version of the System.Data.SqlServerCE from the GAC as opposed to the one it ships with....thus I get this error.

So, is it the approved NT support solution to install SQL CE 3.5, Cumulative Update 6 then, if you have Visual Studio 2010 installed?

[NinjaTrader_Matthew]

Yes, you'll need this specific version installed. Please install this update and let us know if you see this behavior again.