SQL Server Connection Error


J

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);
 
Ad

Advertisements

B

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top