SQL Server Connection Error

[JMS]

hi~
I am trying to connect remote SQL Server from PDA.
My app works in PocketPC2002 emulator. but it did not
work in PDA(CASIO IT 500). Exception is occurred at
Connection open code. Exception message is "Missing
Method Exception".
please help me..thanks

Here's my code.

string strConn = "Server=192.1.1.251; Initial
Catalog=DM_POP; uid=DMPOP; pwd=DMPOP";
SqlConnection objCon = new SqlConnection(strConn);
objCon.Open();
SqlCommand objCom = new SqlCommand("select top 1 name
from TB_DM908", objCon);
SqlDataReader objReader = objCom.ExecuteReader();
objReader.Read();
string name = objReader["name"].ToString();
MessageBox.Show(name);

 

[Brad Syputa - MS]

Hi JMS,

Sounds like not all of the SQLCE cab files are being deployed to your
device. Copy and install the SQLCE cab files from your Visual Studio
installation. My files are in:
\Program Files\Microsoft Visual Studio .NET
2003\CompactFrameworkSDK\v1.0.5000\Windows CE\

I think one other customer has reported an issue like this with the Casio
device. You might search through this newsgroup, or the SQLCE newsgroup to
see if there was a fix other then copying files by hand.