SQL Server Mobile Encountered Problems When Opening The Database.

Hello!
I'm trying to connect a sql ce database from a PPC with WM 2003 to a sql server 2005 database.

I discover the class SqlCeRemoteDataAccess, so i've been trying, unsucessfuly, to get things working.

I googled a lot, i read Ms Articles from MSDN, i read some posts here, but can't find solution for my problem. As you can see in my code, i already tryed different aprroaches, differente connections strings, with "provider", without "provider", with "sspi", without "sspi", you name it...

I configure the sql server agent like i read in msdn, and he's working well, i'm able to see the message. ("Microsoft SQL Server Compact Edition Server Agent" when i open the url).

The sql database credentials are correct, i already check that.

I did everything i knew and i read, unfortunately i still can't manage to find a solution for an error message:

"SQL Server Mobile encountered problems when opening the database." The native error is 28559


That's an Exception error message, that appears to me.

Can somebody help me?

Thank you!





Code Block
string connString = "Data Source=\My Documents\inv.sdf;Persist Security Info=False;";

string rdaOleDbConnectString = @"Data Source=server;Initial Catalog=mycatalog;Integrated Security=SSPI;User Id=myLogin;Password=myPasssword;";


public void ImportDatabase()
{

//rda.LocalConnectionString =@"Data Source=\My Documents\inv.sdf";
//rda.InternetUrl = "http://myserver/sync/sqlcesa30.dll";
//rda.InternetLogin = "myLogin";
//rda.InternetPassword = "myPassword";


SqlCeRemoteDataAccess rda = new SqlCeRemoteDataAccess("http://server/sync/sqlcesa30.dll","myLogin","myPassword",connString);



try
{
// Try the Pull Operation

rda.Pull("localtable", "SELECT Cod, Name FROM People", rdaOleDbConnectString, RdaTrackOption.TrackingOnWithIndexes,"ErrorTable");


}
catch (SqlCeException exc)
{
// Handle errors here
//
MessageBox.Show(exc.Message + "-" + exc.NativeError);
}
finally
{
// Dispose of the RDA object
//
rda.Dispose();
}