Hi,
URGENT!
I'm receiving a missing method exception while trying to instantiate a object that contains simple SQL Client code on Pocket PC 2003 Projects.
I'm using .Net Compact Framework 2.0 with Visual Studio 2005.
The piece of code i post bellow is able to simulate the problem i'm talking about. I just can't see any problems. I've even declarated on the Pocket Project a reference to "System.Data.SqlClient" as a try to solve the problem, without success. I'm working on it for three days and I just can't see any other solutions then the ones i've tried. Please Help!
using System;
using System.Data;
using System.Data.Common;
using System.Collections;
using System.Data.SqlClient;
namespace RCN.TopManager.Net.DAO.SQLDAO
{
public class AbstractDAO
{
protected SqlCommand m_sqlCommand;
protected SqlDataAdapter m_sqlAdapter;
protected SqlTransaction m_sqlTransaction;
protected SqlConnection m_sqlConnection;
public AbstractDAO()
{
}
}
}
MissingMethodException when trying to directly access SQL Server throught .Net Compact Framework 2.0
Vergie
include a reference to System.Data.SqlServerCe and
vstudio2005 will do deploy sqlce on the pda/emulator for you.
cheers
RandyFriend
John Michael Miller
Have you installed SQL Client on to device Can you see it in "Remove programs" applet SQL Client is not a part of NETCF and needs to be installed separately.
Thrailkill
VS should indeed install it if you have a reference to System.Data.SqlClient.dll. Which device are you using and what are details from this exception (e.g. full assembly name with version and PKT) By the way, is your project type matching the device
You can also install SQL Client CAB manually, located here by default:
%ProgramFiles%\Microsoft Visual Studio 8\SmartDevices\SDK\SQL Server\Client\v2.0\<OS>\<CPU>