Connection to Database (SQL CE)

[SiewSa]

I have tried on this for so long but it just never works for me. Here are
my two questions and I am very appreciate if someone can help me on them:

1) My connection coding...

Dim myConnection As New SqlCeConnection("Data Source=\Stephan\mobiledb.sdf")

Error Code : 80004005

Message: The path is not valid, check the directory for the database [,,,
Path ,,].

But, I am pretty sure that I have put the .sdf file in that particular
directory. Am I doing something wrong on just copy the .sdf file to that
directory?

2) SqlCeDataAdapter
Dim myDataAdapter As New SqlCeDataAdapter

When I try to declare a SqlCeDataAdapter, the PC will prompt me an error as
the below:

"Reference required to assembly 'System.Data.Common' containing the base
class 'System.Data.Common.DbDataAdapter'. Add one to your project."

However, even though I have imported System.Data.Common in my class, it
never help. By the way, I am not able to locate the
System.Data.Common.DbDataAdapter namespace. My dotnet framework version is
1.1. Is that the problem of versions??? Or, there are some other reasons?
Indeed, I have already imported the 'System.Data.SqlServerCe' Namespace.

That's pretty much of them and I would like to thank in advance to someone
from you all who is helping me out. Thanks.

 

[Lloyd Dupont]

if you put it at the root of the mobile in the explorer view, then it is
\My Documents\Stephan\mobiledb.sdf

you should reference both the following dll in your project (DLL = different
namespace) System.Data.dll & System.Data.Common.dll (and maybe
System.Data.SqlClient.dll too)