Problem with sql server ce 2.0 on pocket pc...

[dwhittenburg]

I was working with my app that I developed for my pocket pc...moving the app
over to the pocket pc from my laptop...I had it getting a connection and
creating the database on the pocket pc and everything...running queries,
etc...

I recently got a new server to be used as my development machine...Once I
got back to working on the pocket pc application...the pocket pc was hung
up...so i had to cut the switch on the back of my pocket pc off and then
back on to reboot it...well, in doing this...it seem I lost what I had
installed onto my pocket for sql ce 2.0 to work...

I tried to install sql server ce 2.0 using directions from
http://msdn.microsoft.com/library/d...talling_sql_server_ce_with_using_embe_533.asp
and
http://asia.cnet.com/builder/program/windows/0,39009376,39172017,00.htm
I seem to have left something out...

I basically moved all of the .dlls and .exe over to a directory under
program files (maybe this is wrong location?) and then I ran the
dllregister.exe and it said that it completed fine...

I can access a database on my pocket pc from my pocket pc just fine...create
a new one etc...however in my program now it blows up when it gets to the
point of me trying to dim out a connection...I'm doing:
Dim oConn as sqlCeConnection

Any help is appreciated...I seem to remember using a cab file to install sql
ce last time, but this time i did not do that...and I don't see that
anywhere in either web-site...

Thanks

 

[dwhittenburg]

btw...the error that I'm getting when trying to run the app on the pocket pc
is TypeLoadException...

 

[Sergey Bogdanov]

Make sure that you have installed SqlCE client correctly. Do you have
GAC_System.Data.Common... and GAC_System.Data.SqlClient... in the
/windows directory for your device?

Best regards,
Sergey Bogdanov
http://www.sergeybogdanov.com

 

[dwhittenburg]

I do not have those in my windows directory...
I remember having to do something on the initial run of the program that
loaded something on the pda...you could actually see it loading something
before running the app....I cannot remember now...