SQL Server CE Error - Only on Compiled Code

Question

I have a strange error that causes my application to crash. This only happens when compiling and installing through a single click, and not when debugging in Visual Studio.

Viewing the event log gives me the following:

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name="Windows Error Reporting" /> <EventID Qualifiers="0">1001</EventID> <Level>4</Level> <Task>0</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2015-04-27T14:51:30.000000000Z" /> <EventRecordID>6471</EventRecordID> <Channel>Application</Channel> <Computer>me.local</Computer> <Security /> </System> - <EventData> <Data /> <Data>0</Data> <Data>CLR20r3</Data> <Data>Not available</Data> <Data>0</Data> <Data>calibration certificate builder</Data> <Data>1.0.0.0</Data> <Data>553e4aaa</Data> <Data>System.Data.SqlServerCe</Data> <Data>3.5.8080.0</Data> <Data>4b743b2d</Data> <Data>e3</Data> <Data>0</Data> <Data>System.ArgumentNullException</Data> <Data /> <Data>C:\Users\me\AppData\Local\Temp\WER80E0.tmp.WERInternalMetadata.xml</Data> <Data>C:\Users\me\AppData\Local\Microsoft\Windows\WER\ReportArchive\AppCrash_pick_cert_e053eebdc3d787d726058a9b0d3405c6f279444_3b258dcb</Data> <Data /> <Data>0</Data> <Data>e12fbed6-ecec-11e4-b276-24fd52358985</Data> <Data>65</Data> </EventData> </Event> 

I am not sure how to handle this. I looked through my code and it seems like this is not a problem. This seems to be somewhere inside the SQL Server CE code, but I could not find it.

I also pushed the line event.ExceptionObject into a text file and got the following:

System.ArgumentNullException: value cannot be null. in System.Threading.Monitor.Enter (Object obj) in System.Data.SqlServerCe.SqlCeCommand.Dispose (Boolean disposing) in System.Data.SqlServerCe.SqlCeCommand.Finalize ()

Can someone help me interpret this?

I removed the use of SQL CE services from other threads. I also deleted the removal of the SQL CE connection, as well as the finally blocks, but the error logs remained the same.

Is removing a connection the cause of the problem?

Answer 1

I assume that you are trying to connect to the SQL database using the Windows connection string, and this person does not have access to the sql database. Try changing the connection string with user ID and password. Change "Data Source=URDATABASE;Initial Catalog=MYDATABASE;Integrated Security=True" to "Data Source=URDATABASE;Initial Catalog=MYDATABASE;Uid=UrUserID;Pwd=MyPassWord;"