Re: RDA Pull - Error - URGENT HELP . Please...
From: Nick Hoggard (nickh_at_N0_SPAMxenacom.com)
Date: 09/01/04
- Next message: PeterS: "Checkpoint Smart Client issues for Pocket PC"
- Previous message: Stuart: "Re: Two Pockets with Bluetooth..."
- In reply to: AJK: "Re: RDA Pull - Error - URGENT HELP . Please..."
- Next in thread: AJK: "Re: RDA Pull - Error - URGENT HELP . Please..."
- Reply: AJK: "Re: RDA Pull - Error - URGENT HELP . Please..."
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 2 Sep 2004 07:23:32 +1200
Hi,
> Now, I'm getting following message when I run the program from Development
> machine. This error comes upom execution of RDA.Pull
>
> 'The Table does not have primary key. Error# 29010.
>
> Below is the command I tried
>
> rda.Pull("CMF", "Select Acct_Number,Acct_Name from m01 where acct_ibu =
> 'DAD'", rdaOleDbConnectString, RdaTrackOption.TrackingOn, "ErrorTable")
Since you are using RdaTrackOption.TrackingOn the table you are quering on
the server needs to have a primary key set. Can you please check if table
m01 on your server database has a primary key?
Nick
> Any idea why this error.
>
> "Nick Hoggard" wrote:
>
> > Hi,
> >
> > > As I mentioned in my post, upon typing of
> > > "http://localhost/nwind/sscesa20.dll" follwing message has got
> > > "SQL Server CE Server Agent".
> >
> > The reason I was asking about this was that the inclusion of localhost
in
> > this address made me wonder if you were typing it from the development
> > machine, rather than the device itself. I was just suggesting trying it
> > from the device to see if it was able to contact the server ok. You
would
> > need to use the machine name or IP address insted of localhost in this
case.
> >
> > > IIS config OK. But, I have installed SQL CE on my development machine
and
> > > configured the SQL CE with IIS. SQL SERVER 2000 is not running on my
> > > developement machine which is on another win2k server (live).
> > >
> > > Here is my confusion.
> > >
> > > Shall I install SQL CE on the machine where SQL Server 2000 running
and
> > > configure the IIS ?.
> >
> > This shouldn't matter so long as you have installed the sql server ce
tools
> > on the machine with IIS running (which you must have if you have
> > sscesa20.dll on the server).
> >
> > > If above is required, sould I keep SQL CE on my development machine. I
> > have
> > > installed following on my developement machine (win2k professional):
> > >
> > > VS.NET 2003
> > > Pocket PC 2003 SDK
> > > ActiveSync (I don't the requirement of this !!!)
> >
> > This just provides the transport connection between your device and the
> > server.
> >
> > > SQL CE 2.0
> >
> > Have you tried placing a catch block around the PULL command? You might
> > find that the errors collection of the SqlCeException object will
provide
> > further information about the error that might be helpful.
> >
> > Also in the implmentation I am using at the moment I am wrapping the
.pull
> > command in a loop that will attempt to get the data 5 times before
failing.
> > This was to combat periodic networking issues that we were encountering,
but
> > I don't think thats the case for you since it is happening every time.
> >
> > Sorry I could not be more help.
> >
> > Nick
> >
> > >
> > > "Nick Hoggard" wrote:
> > >
> > > > Hi,
> > > >
> > > > Can you double check your device has network connectivity .. eg try
to
> > get
> > > > to http://machinename/nwind/sscesa20.dll from IE on the device.
What
> > happens
> > > > then?
> > > >
> > > > Nick
> > > >
> > > >
> > > > "AJK" wrote:
> > > >
> > > > > Hi,
> > > > >
> > > > > I'm using POCKET PC 2003 Emulator to test my applicaiton from
> > development
> > > > > machine. But, I'm getting following error message upon excution of
> > "RDA.Pull
> > > > > Method.
> > > > >
> > > > > Error: 80072EFD
> > > > > Message: A request to send data to the Computer running IIS has
> > failed.
> > > > >
> > > > > Have checked the solution in BOL whcih describe as shown below:
> > > >
> >
> --------------------------------------------------------------------------
> > ---
> > > > > The user's device must have network connectivity. For example, the
> > device
> > > > > might not have a working modem, network card, or universal serial
bus
> > (USB)
> > > > > connection
> > > > >
> > > > > I have also checked IIS configuratin using IE. It's working fine
and I
> > got
> > > > > the message
> > > > > "SQL Server CE Server Agent". upon typing of
> > > > > "http://localhost/nwind/sscesa20.dll).
> > > > >
> > > > > My SQL SERVER 2000 is not on my developement machine which on
another
> > Server
> > > > > in the same location. Would it be a problem ? Or I miss anything
to my
> > > > > development machine.
> > > > >
> > > > > Kindly advise..
> > > > >
> > > > >
> > > > >
> >
> >
> >
- Next message: PeterS: "Checkpoint Smart Client issues for Pocket PC"
- Previous message: Stuart: "Re: Two Pockets with Bluetooth..."
- In reply to: AJK: "Re: RDA Pull - Error - URGENT HELP . Please..."
- Next in thread: AJK: "Re: RDA Pull - Error - URGENT HELP . Please..."
- Reply: AJK: "Re: RDA Pull - Error - URGENT HELP . Please..."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
