PC Review Forums Newsgroups Microsoft DotNet Microsoft Dot NET Compact Framework Port to VS2005 and SQL CE 3

Reply

Port to VS2005 and SQL CE 3

 
Thread Tools Rate Thread
Old 01-12-2006, 02:02 PM   #1
Harry Simpson
Guest
 
Posts: n/a
Default Port to VS2005 and SQL CE 3


I've ported an app from VS2003 to VS2005. I've installed both SQL Server
2.x and 3.x server tools so both have their IIS agent running. When I run
the app now in debug with the following code snippit, I get an error :

With rda
.InternetLogin = String.Empty
.InternetPassword = String.Empty
.InternetUrl = _strInternetURL
.LocalConnectionString = g_strlocalDataSource
.Pull("Devices", strSQL, _strRemoteConnect,
System.Data.SqlServerCe.RdaTrackOption.TrackingOff)

_strInternetURL = "http://10.0.0.69/SSCE30/sqlcesa30.dll"

g_strlocalDataSource = "Data
Source=\Application\EasyTAG.sdf;password=eid2416TN;encrypt database=TRUE"

strSQL = "Select * From t_ezDevices"

_strRemoteConnect = "provider=sqloledb;data source=10.0.0.69;user
id=phgt;password=eid2416TN;initial catalog=EasyID"

?ex.Message
"Header information is either corrupted or missing. [,,,Header name,,]"

yet

?ex
{System.Data.SqlServerCe.SqlCeException}
Errors: {System.Data.SqlServerCe.SqlCeErrorCollection}
HResult: -2147012746
InnerException: Nothing
Message: "SqlCeException"
NativeError: 28035
Source: "Microsoft SQL Server 2000 Windows CE Edition"

**********************************************************
Why the SQL Server 2000 Windows CE Edition error if I'm using 3.0 against
the SQL Server 2005 database?

Has the syntax changed for RDA pull from VS2003 to VS2005??

TIA
Harry



  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off