System.Data.SQLite

 Hi all!

 I'm writing pocket pc application with vs2008, started two days ago and still sqlite doesn't work. I went through all that stuff described in forum:

 1. I created sqlite database with designer, and when i deployed to windows emulator got Interop.dll error, so i add dll to my project as content and hit copy always. That did the trick

2. Then I was facing could not open database problem, so i again copied database to project as content, and my connection string look now like this "data source=flspeedmobiledb" and i stop receiving that error

Finally now i'm gettin exception SQLiteError no such table while i'm sure that table exists.

 Really need help with this :( 

Adrian

P.S sorry if my english is bad 

Adrian Serafin:

my connection string look now like this "data source=flspeedmobiledb" and i stop receiving that error. Finally now i'm gettin exception SQLiteError no such table while i'm sure that table exists.

I'm using vs2008 so i go to the dataset and in properties window i change ConnectionString field to "|DataDirectory|flspeedmobiledb" and again deploy application, but still getting the same error.

 Also I typed in immediete window this.Connection.ConnectionString and i get: 

"data source=flspeedmobiledb"

 Thanks for your reply btw

Adrian Serafin:

I typed in immediete window this.Connection.ConnectionString and i get: "data source=flspeedmobiledb"

 Hi! 

it looks like youre right, but i have no idea why, i've done everything from scratch, add new data source, test connection and put |DataDirectory|flspeedmobiledb and now i'm gettig the unable to open database error and my connection string from immediete window is 

"data source=\"C:\\Documents and Settings\\adrian\\My Documents\\Visual Studio 2008\\Projects\\FlSpeedMobile\\FlSpeedMobile\\bin\\Debug\\flspeedmobiledb\""

so as you've said it do not process  |DataDirectory|flspeedmobiledb.

Do you know how absolute path on windows mobile should look like?? Maybe I just copy file by hand...

The Immediate Window probably is reflecting the design-time expansion of |DataDirectory|. If you actually run your program in the device emulator or on a real device, do you still get the error?

If you want to hard-code the path as a test, for your mobile application it probably would be something like: "\Program Files\FLSpeedMobile\flspeedmobiledb"

It often is helpful to poke around the device's filesystem with a browser. There are several good ones. For example Total Commander (http://www.ghisler.com/pocketpc.htm).

 Ok, I copy file by hand to emulator using activesync explorer, hard code path  and now it works. 

But it will be paintfull in the ass to hand copy the file always when i want to add some changes ;) 

Thanks for your help :) 

 good day sir,

may i know how to copy files to emulator using activesync explorer?