Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 SQL CE

Author  Topic 

tech1
Starting Member

49 Posts

Posted - 2005-04-23 : 05:19:31
Hi there. Sorry if this is the wrong place to post this - I am new here.

I have a smartphone, and i have installed the compact framework as well as SQL Server CE in Windows for the .NET development.

Basically i want to be able to create databases and tables on a smartphone. Sounds simple enough.

I am dev'ing in C# - added a reference to System.Data.SQLServerCE.dll and all compiles fine

The problem I am having is this....

When you create a new SQLCEConnection object, when you do something like "connection.open();" I get an exception:

MissingMethodException.

What is this? What have i done wrong? my connection string is as follows:

string theConnectionString = "Data source=\\test.sdf;";
SQLCEConnection theConnection = new SQLCEConnection(theConnectionString);

try
{
theConnection.Open();
}
catch (Exception e)
{
MessageBox.Show(e.ToString());
}
finally
{
theConnection.Close();
}


what is wrong?

I appreciate your help :)
   

- Advertisement -