Re: CE Emulator and RDA

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Alex Feinman [MVP] (public_news_at_alexfeinman.com)
Date: 09/27/04 

Date: Mon, 27 Sep 2004 00:26:40 -0700

Do you get an error, or does the pull succeed but produces nothing?
If latter, can you perhaps run SQL Profiler on the server to see which query
is actually issued? 

-- 
Alex Feinman
---
Visit http://www.opennetcf.org
"Bob Clegg" <bob@nowhere.com> wrote in message 
news:uoSv5XpoEHA.2380@TK2MSFTNGP14.phx.gbl...
> Hi,
> Can anyone tell me what I am doing wrong?
> I am trying to make my first simple CE project that uses RDA.
> When I try to execute the rda.pull method I get
> "An internal error occured. [ID,,,,,,]"
> So...
> 1) Installed sqlce20sql2ksp3a
> 2) Used the connectivity support wizard to create a virtual directory
> 'rdaTest' with anonymous access.
> 3) Added the internet user IUSR_ComputerName to SQL Server logins and to 
> the
> Northwind database
> 4) created a C# CE windows app that checks / deletes then creates
> 'rdatest.sdf' in the application startup
> 5) added a button to the form that executes the example pull code from CE
> help. (With appropriate alterations).
> 6) Do an 'F5' to deploy and debug.
> The sdf creation goes OK. It only spits the dummy when the .pull is
> attempted.
>
> Have I missed something fundamental here?
> Button code follows.
> Thanks
> Bob
>
> // Connection string to the instance of SQL Server
>
> string rdaOleDbConnectString = "Provider=sqloledb; Data
> Source=HellFire;Initial Catalog=Northwind" ;
>
>
> // Initialize the RDA object.
>
> SqlCeRemoteDataAccess rda = null;
>
> try
>
> {
>
> //Try the Pull operation.
>
> rda = new SqlCeRemoteDataAccess();
>
>
> //rda.InternetLogin = "MyLogin";
>
> //rda.InternetPassword = "<password>";
>
> rda.InternetUrl = "http://192.168.1.34/rdaTest/sscesa20.dll";
>
> rda.LocalConnectionString = 
> @"Provider=Microsoft.SQLSERVER.OLEDB.CE.2.0;Data
> Source=\test.sdf";
>
>
> rda.Pull(
>
> "Employees",
>
> "Select * from Employees",
>
> rdaOleDbConnectString,
>
> RdaTrackOption.TrackingOnWithIndexes,
>
> "ErrorTable");
>
> }
>
> catch(SqlCeException ex)
>
> {
>
> //Use your own error handling routine.
>
> //ShowErrors(e)
>
> string s=ex.Message;
>
> string s1=s; //*************at this point s= 'An internal error Occured.
> [ID,,,,,,]'
>
> }
>
> finally
>
> {
>
> //Dispose of the RDA object.
>
> rda.Dispose();
>
> }
>
>
Quantcast