Re: Problem with Push Method

Tech-Archive recommends: Fix windows errors by optimizing your registry

Sanjeev,

I did see that post, but didn't respond because I have not tried to
work with a sproc that uses a hashtable via RDA submit sql. The
fastest solution to this may be to first try to make an RDA submit sql call
to a simple sproc that is a test call just to verify your configuration and
general syntax. Then see if you can simplify the hashtable into something
that RDA can handle.

Sometimes, in exchange for SQL Server CE's 1MB footprint, you have
to make some adjustments and simplify things you would normally think
nothing of doing with SQL Server 2000.
--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"Sanjeev Yamdagni" <sanjeev@xxxxxxxxxxxxxxx> wrote in message
news:e3gPUgqQFHA.3288@xxxxxxxxxxxxxxxxxxxxxxx
> Thanks Darren for the help.
>
> Darren, I am also facing another problem which I have found a work around
> but would like to have your opinion.. I had posted this on 4/11/2005 but
> so far did not get any response. I am pasting that issue below. Please let
> me know, what do you think could be problem ?
>
> Regards
>
> ~Sanjeev
>
>
>
> Hi,
>
> I am developing a mobile application for Pocket PC and using Pocket PC
> 2003 Emulator. I am using RDA to pull the data information on the mobile
> device.
>
> When I use "EXEC sp_MyStoredProcedure {Parameters}" the RDA Pull function
> works fine and creates table on the local sql ce database as long as the
> SP DOES NOT use hash tables. The problem is that if SP called uses a Hash
> Table then rda.pull() does not give me any error but it does not create a
> table on local sql ce database.
>
> RDA.PULL WORKS for sp_MyStoredProcedure having code like:
>
> CREATE PROCURE sp_MyStoredProcedure
>
> AS
>
> BEGIN
>
> Select * from tblUser
>
> END
>
>
>
> RDA.PULL DOES NOT WORK for sp_MyStoredProcedure having code like:
>
> CREATE PROCURE sp_MyStoredProcedure
>
> AS
>
> BEGIN
>
> Create Table #Users( Name varchar(100), UserID varchar(15), Password
>
> varchar(20))
>
> Insert into #User
>
> Select * from tblUser Where blah blah..
>
> Select * from #Users
>
> END
>
>
>
> I certainly need to get this SP with hash table work with RDA pull method.
>
> Any help will be greatly appreciated.
>
> Regards
>
> ~Sanjeev
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> "Darren Shaffer" <darrenshaffer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
> message news:<ec7s4$gQFHA.812@xxxxxxxxxxxxxxxxxxxx>...
>
>> no, once you do the first push, the table is assumed to be synch'd
>
>> with the server (if push succeeded and no rows were in error) and the
>
>> table on device is no longer being tracked. a subsequent push doesn't
>
>> know what you are talking about. if you have a high-bandwidth
>
>> connection, you might consider switching to merge replication.
>
>> --
>
>> Darren Shaffer
>
>> .NET Compact Framework MVP
>
>> Principal Architect
>
>> Connected Innovation
>
>> www.connectedinnovation.com
>
>>
>
>> "Sanjeev Yamdagni" <sanjeev@xxxxxxxxxxxxxxx> wrote in message
>
>> news:%23ZRsAygQFHA.204@xxxxxxxxxxxxxxxxxxxxxxx
>
>> > Hi Everybody,
>
>> >
>
>> > I am developing a mobile application for Pocket PC and using Pocket
>
>> > PC
>
>> > 2003Emulator. I am using RDA to pull and push for data transfer between
>
>> > pocket pc and server.
>
>> >
>
>> > Among many tables I am pulling on empty table which gets populated
>
>> > by a
>
>> > pocket pc app and needs to push the new data to the server.
>
>> >
>
>> > I am PULLING the data using the following commands and it works
>
>> > fine. sqlCmd = "SELECT * FROM tblRoster WHERE 1=2"
>
>> >
>
>> > rda.Pull("tblRoster", sqlCmd, m_Conn.RemoteConnectionString,
>
>> > RdaTrackOption.TrackingOnWithIndexes)
>
>> >
>
>> > I am PUSHING the table using the following command.
>
>> >
>
>> > rda.Push("tblRoster", m_Conn.RemoteConnectionString,
>
>> > RdaBatchOption.BatchingOn)
>
>> >
>
>> > The problem is that the above command works fine only one time. Like
>
>> > we
>
>> > add some data to the table and Push .. it works fine. .. but then we
>> > add
>
>> > some more data and again call Push.. then this method fails .. It says
>
>> > "The table cannot be opened. [,,,Table Name,,]" followed by another
>> > error
>
>> > "The specified table does not exist"
>
>> >
>
>> >
>
>> > Can we not do two times Push. ( without pulling in between)?
>
>> >
>
>> >
>
>> > Please help ...
>
>> >
>
>> > ~Sanjeev
>
>> >
>
>>
>
>>
>
>


.

Relevant Pages

  • Re: Can I use Remote Data Access and Merge Replication with MSDE?
    ... What you are missing is the key to how RDA currently works on the pocket ... kind of syncronization method with MSDE (SQL Express). ... >> framework Pocket PC app and a standard .NET framework app if I don't have ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: Can I use Remote Data Access and Merge Replication with MSDE?
    ... What you are missing is the key to how RDA currently works on the pocket ... kind of syncronization method with MSDE (SQL Express). ... >> framework Pocket PC app and a standard .NET framework app if I don't have ...
    (microsoft.public.sqlserver.ce)
  • Re: Push Error
    ... Tables are pulled from SQL & ... > I have received a push error (The push method returned one ... > The record is received at the Server side. ... > I did not think this could happen using RDA Push because i ...
    (microsoft.public.sqlserver.ce)
  • Push Error
    ... Tables are pulled from SQL & ... I have received a push error (The push method returned one ... The record is received at the Server side. ... I did not think this could happen using RDA Push because i ...
    (microsoft.public.sqlserver.ce)
  • Which method to use?
    ... I have a pocket pc application, also i have with it an sql ce db, the ... Merge/Replication or RDA? ... Prev by Date: ...
    (microsoft.public.sqlserver.ce)