SQLCE dll references

[dazjack1]

Hi There,

This is probably a fairly basic question but it i cant seem to find the answer.

can anyone tell which references i need to set in the applications property pages in order to correctly access and update an SQL mobile 2005 .sdf database file.

The application i have was originally written using visual studio 2005 (vb) and worked fine on a wm5.0 device.

I have since redesigned the program changing the layout of the forms and copied the existing code into a wm6 project. since doing this ive found that the database i'm accessing becomes corrupt all the time.

As i havent changed any data access code i'm guessing it is related to the different versions of the .netcf on the wm6 device.

if anyone else has had the same problem when moving to wm6 it would be great to hear how you resolved it.
or if you can tell me which dll files i should be referencing.

Also when i deploy the application it doesnt install the query analyser on the device which it used to with the wm5.0 application.

thanks

[petevick]

What version of SqlMobile did your original version target - if it was 2.0 then there is an 'upgrade' program to take your sdf from 2.0 to 3.0

[dazjack1]

Thanks for your reply

I've checked and both versions reference the system.data.sqlserverce.dll from the SQL server mobile edition 2005\V3 folder.

However the sdf file was created using sqlserver2005(full) which uses .net v2?

ps i am new to sqlserver and am having to learn as i go so any assistance you can give will be greatly appreciated.

Darren

[petevick]

Hi,

sorry I don't understand "However the sdf file was created using sqlserver2005(full) which uses .net v2?"

[dazjack1]

Sorry, bout that - it was created using SQL management studio (which in my head i always associate with the Full SQL Server software - Sorry!) and which references .net framework version 2.

[petevick]

Hi,
i don't understand what you mean by 'copied the code into a WM6 project' - all you need to do is change the target platform in your original project.
If you mean you have moved to VS2008, then the database will have moved to 3.5

What errors are you getting?

[dazjack1]

Hi there,

I was changing the complete layout of the application and moving the controls onto tabbed pages instead of separate forms. Because of this I thought it would be easier to copy and paste the controls into a new project (which i set up as windows mobile 6) and then also paste the relevent code, changing lines where neccessary.

Overall the only code changes that have been made relate to which control triggers the procedure or which control has the data needed for the procedure. the actual Data Access / edit / update code hasn't changed.

The error message is "your database may be corrupt - please run the repair utility"

Prior to making these changes this message was rare, maybe once every 3months between the 10 - 15 PDA's that we have in use. unfortunately now i seem to be getting this message a few times a day.

Also the database corruption is not linked to any particular procedure, it will work fine for hours and then on some occasions it will become corrupt every other update.

[petevick]

Is the database on a storage card?
Does it repair ok?

[dazjack1]

Yes is on storage card and most times it does repair but have also noticed missing data after repair on a couple of occasions.

I'm currently trying the same software with a brand named Card to rule out the chances of it just being a hardware compatabilty issue.

Also havent mentioned before but the PDa i'm using is an HP Ipaq 214 and the old PDA with windows mobile 5.0 was a dell Axim x51v. neither of which seemed to have a problem prior to the changes in my application.

[petevick]

Have you tried it in storage as opposed to the card?

Remember, SD Cards have a 'limited' lifetime as far as writes are concerned - how old are the cards, and for how long have they been used?