SQL CE 4 TO 3.5

Question

Hello, sorry for my bad english:

I have an app that runs in 32-bit OS that create a SQL CE 3.5 database to load the DB in a PDA. But my client have to run the app on a 64-bit OS so i updated the sql ce to 4. But i found that SQL Server Compact 4.0 does not have a release for Windows Mobile. So i wanted to know if sql ce 4 can create a sql ce 3.5 DB or if i can copy my data from the db 4 to 3.5?

Thank you.

Answer 1

SQL Compact 3.5 SP2 is available for both x86 and x64.

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog

Answer 2

Hey

I just install the new dlls but i get an error when im trying to create the database:

An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)

and my application isnt working non 32 bit or 64 bit.

Answer 3

Hello after a lot of investigation i could solve it.

But now when i try to load my database that i generated, my device sends an error that the file is not valid

what should i do? sql ce 3.5 is compatible ?

thanks and greetings

Answer 4

Greetings

One more question

Do i have to use VS 2008 ?

Answer 5

For Windows Mobile Development, yes.

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog

Answer 6

Please start a new thread with enough information to help you on this new question.

---

Please mark as answer, if this was it. Visit my SQL Server Compact blog