SQLCE Push pb on VB.Net Compact Framework

From: fleurdefarine_at_hotmail.com ((fleurdefarine_at_hotmail.com))
Date: 08/26/04 

Date: Thu, 26 Aug 2004 08:31:30 -0700

SQLCE Push pb

I have a VB.net compact framework program written in VB. Net on a pocket

pc 2003 that uses a SQL CE database.

I'm using RDA to sync the ce db with a sql server db.

I have SQL Server tables with "dbo" owner and some have specific owner.

The tables with owner "dbo" are sync with no pb - the pull and the push

go perfectly.

But I get some pb to push the tables defined with a specific owner (not

dbo).

The Pull was working fine - We named the table including the owner, like

this "CC.CC_ACCOUNTS". The CC. is the owner.

But when I try to push these tables back I get this error:

Table cannot be opened [,,, Table Name ,,,]

However if I go into Query analyzer on the device I can open the table

and perform operations.
Anybody know why this is happening?

I found this at

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/sqlce/h

tm/_lce_errors_client_agent_errors.asp
error descripion

parameters error
28567 The table cannot be opened. P3: Table name

       SSCE_M_OPENTABLEFAILED

but I can't find anymore info

Can anyone help me?

**********************************************************************
Sent via Fuzzy Software @ http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

Relevant Pages

  • Re: rda push when owner is not dbo.
    ... If I launch the sql query analyzewr and try to run the ... I'm pretty configdent that the owner name not being qualified is the ... > I pull the table with rda to a local table named task. ... > I also created a test table in the same database with owner dbo and I ...
    (microsoft.public.sqlserver.ce)
  • Re: db_owner role in SQL 2k
    ... Role membership doesn't affect the owner of an object. ... power to create objects owned by other users, including owned by dbo. ... SQL Server MVP ... "John" wrote in message ...
    (microsoft.public.sqlserver.programming)
  • Re: User names
    ... a dbo or sa it will use dbo as the owner. ... Andrew J. Kelly SQL MVP "Laura K" wrote in message ... > The issue was resolved by installing SP3 for SQL server. ...
    (microsoft.public.sqlserver.server)
  • Re: Missing table
    ... execute the commands within Query Analyzer. ... The first piece of sql displays the table owner, type, and the name of the table. ...
    (microsoft.public.sqlserver.server)
  • RE: Is the Folowing Applicationb Possible
    ... Therfore are you saying it is possible to create a useable app ... that uses SQL properly - but based around Sharepoint 'front end' AND is easy ... Then have a drop down list so that a users could easliy pick the owner. ...
    (microsoft.public.sharepoint.windowsservices)