interesting...missingmethodexception?

[Techno]

hi there.

Sorry if i have posted in the wrong forum.

Basically, i am developin a SQL SERVER CE application.

I have added a reference to SQLSERVERCE.DLL (using Visual C# to develop)
the problem i am having is that I cannot either open a connection or create a database. Everytime i do this, i get a missing method exception

any ideas what I am doing? All i have done so far is to either open a connection or create a database using SQLSERVERCE

Thanks!

[hellswraith]

Not sure of the exact name, but have you referenced the System.Data.Common? (the CE version, not the standard one)

[Techno]

ive tried that too

[hellswraith]

You are using a SqlCEConnection object and not the regular SqlConnection object right?

There are so many variables, can you show some code?

[Techno]

lol yes im using the sqlCE connection object!
when it gets to creating the SQLCEEngine object, it gives me that error

try
{

             SqlCeEngine theEngine = new SqlCeEngine("Data Source = Test.sdf");
	theEngine.CreateDatabase();
	SqlCeConnection theConn = new SqlCeConnection("Test.sdf");
	theConn.Open();
	theConn.Close();
}
catch (Exception a)
{
	MessageBox.Show(a.ToString());
}

[hellswraith]

I will look at some code I have at work tomorrow and see if I notice anything special.