System.Data.SQLite

Hi.

I try to use SQLite with C# and VS2008. I try to make a windows mobile application. In my solution have 2 projects. one a windows mobile application, the other a class library project. In the class library project i try to write a Data Access Layer....

I added the sqlite3.dll as reference, with using System.Data.SQLite; i write my code, but when i try to run in the emulator or in a WINMO PPC i got this error

System.MissingMethodException was unhandled
  Message="Can't find PInvoke DLL 'SQLite.Interop.063.DLL'."
  StackTrace:
       at System.Data.SQLite.SQLite3.Open(String strFilename, SQLiteOpenFlagsEnum flags, Int32 maxPoolSize, Boolean usePool)
       at System.Data.SQLite.SQLiteConnection.Open()
       at Classes.DAL.MakeConnection()
       at Classes.DAL..ctor()
       at Classes.CLogin..ctor()
       at TestApp.Form_Login..ctor()
       at TestApp.Program.Main()

Please somebody help me..

thx

(i dont find the search box in this forum, maybe have others posts with this topic. if have im sorry for cuz, i open another one)

 I think you need to copy the SQLite.Interop.063.dll to the device and/or the emulator. I put it in the root 'cause I don't know any better.

 i can`t find that DLL, but i guess it cause another problem.. (maybe i screwed up something..really dont know)

 i found the dll, i tried to copy to the emulator but the emulator dont see that dll in the shared folder (other files are visible)....

i tried to copy the dll into the project debug folder but without luck... it don`t helped, i tried to add as reference but the VS2008 sais i can`t add this dll as reference...

it works, neet to copy the dll into the phone, or in the emulator near the compiled exe.

 I am having the same problem, but I don't know where to copy the dll, or what dll it should be.

is it the system.data.sqlite.dll that you would use with 32bit .Net apps? or is there one for mobile I should be using?

what directory are the emmulators in?

 As for what .dll, it's the one that's missing, which we know.

As for where, try root like I did, or the app folder. 

 I only asked which one because of another post that specified the interop dll should never be needed unless compiling system.data.sqlite from source, which I was not, so I was unclear if that indeed was the problem.

 Turns out I needed both dlls, the SQLite.Interop.065.DLL and a system.data.sqlite.dll specified for mobile. "root" or "app folder" mean nothing if I don't know where the emulator is typically run from or have a mobile device to install to. Another post I found finally told me something useful (http://sqlite.phxsoftware.com/forums/p/1569/8573.aspx#8573).

Try to cradle the device or emulator, this will ActiveSync the device. Then Explore and drill folder My Windows Mobile-Based Device. You are now in root, copy the interop file there.

 If you are using the emulator, from VS 2005 go Tools, Device Emulator Manager. Find the device in the list, right click to connect and cradle the emulator.