.NET raises Native exception in SQL Compact on WinCE

[hairy_hats]

Hi all, I'm running a .NET CF 2 application on WinCE, accessing a SQL Compact 3.5 database, and calling SqlCeDataAdapter.Fill() raises an error:

ExceptionCode: 0xC0000005
ExceptionAddress: 0x01a7438C
Reading 0x00000000

It seems to be caused by the underlying native DLLs but I cannot trap the error using C# exceptions. Any suggestions as to the likely cause/possible solution please? TIA! :beer:

[Covean]

0xC0000005 means Access Violation while reading address 0x00000000 (null). Take a look at your code and try to find out if you set some null parameter or something else.

Greetings Covean

[hairy_hats]

I'm calling it from C# using allocated variables, and the database is being opened without error. Accessing it using totally different code also raises the same error.

[Covean]

Without some code it will be hard to say where the error lies. Especially access violations are not that rare and can have a wide range of causes. It also can be a bug in the underlaying system (what I don't believe), but in most cases the programmer causes this problem.

Greetings Covean

[hairy_hats]

Thanks for the reply, this is the code - it crashes on the last line. It also crashes when filling a DataTable.

SqlCeConnection conn = new SqlCeConnection( connectionString );

conn.Open();

SqlCeCommand selectCmd = conn.CreateCommand();

selectCmd.CommandText = @"Select Value From MyTable where ColumnOne=101";

SqlCeDataAdapter adp = new SqlCeDataAdapter( selectCmd );

System.Data.DataSet ds = new System.Data.DataSet();

adp.Fill( ds );

[Covean]

Your code looks good and should execute without problems. Is any stack trace of this error available? (The complete trace from adp.Fill(...) to the access violation would be nice)

Greetings Covean