Re: Generated fields in CE table

From: Linda Lalewicz (LindaLalewicz_at_discussions.microsoft.com)
Date: 11/01/04


Date: Mon, 1 Nov 2004 12:38:04 -0800

This may have been the most valuable piece of advice I have ever gotten in
this whole mess. Thank you. It helps a lot to have some more information. I
found that the snapshot was obsolete and we have to re-do it. Still getting
errors but moving forward. I have to wonder why it is so hard getting this
information in the first place. Wouldn't it have been easier if the
developers had built this sort of error reporting into the process without
additional code?

"Kevin Collins (MS - SQL Mobile)" wrote:

> Linda, are you checking all the errors in the error collection after the
> ..synchronize method?
>
> Please refer to the ShowErrors routine in the sample application that ships
> with VS 2003. Please reference this one C:\Program Files\Microsoft Visual
> Studio .NET 2003\CompactFrameworkSDK\v1.0.5000\Windows CE\Samples\VB\Pocket
> PC\NorthwindCE
>
> The following errors in the error collection can provide more detailed
> informaiton about what is occuring with SQL Server.
>
> "Linda Lalewicz" <LindaLalewicz@discussions.microsoft.com> wrote in message
> news:EB7690C1-2076-4950-A0EA-C2F30C04C80B@microsoft.com...
> >I never could figure out how to bind the data to the grid in the compact
> > environment by name, but like I said I realized that I was referencing two
> > different tables. They were so similar that I had trouble catching it.
> >
> > Now my problem, and there always is one with this project, is that I
> > added
> > an article to the publication on the SQL server using enterprise manager.
> > and
> > now I am getting an error that reads "Initializing SQL Server Reconciler
> > has
> > failed" when I try to sync. I do not have an idea in the world how to
> > rectify this thing. Arghhhhhhh! And I thought that I was so close.
> >
> > "Kevin Collins (MS - SQL Mobile)" wrote:
> >
> >> The columns are used by SQL CE for tracking changes. Can you bind the
> >> columns by name instead of by order?
> >>
> >>
> >> "Linda Lalewicz" <Linda Lalewicz@discussions.microsoft.com> wrote in
> >> message
> >> news:316A5F3C-1A85-4D6F-9D09-9CAF4855F986@microsoft.com...
> >> > When I get a subscription to a CE table down on my pocket pC there are
> >> > 3
> >> > columns that are generated:
> >> >
> >> > s_Generation
> >> > s_RowLineage
> >> > rowguid
> >> >
> >> > I don't mind the columns as they are neccesary (ofr something I am
> >> > sure)
> >> > but
> >> > my problem is, the first time I bind the table to a datagrid they do
> >> > not
> >> > appear, only after a search and edit and then a refresh of the data do
> >> > they
> >> > make their appearance in the datagrid. This causes a problem in that
> >> > tehe
> >> > next time I reference a grid column position to fill a box or
> >> > soemthing, I
> >> > get a column other that what I orignially coded for.
> >> >
> >> > What is happening and how can I control it?
> >> >
> >> > Thanks in advance.
> >>
> >>
> >>
>
>
>



Relevant Pages

  • Re: ADO/MDAC on Terminal Server
    ... XP database system to SQL Server 2000. ... front end is running on the Terminal Server. ... MDB file due to fixes and modifications, ... "missing reference" error as the MDB file opens up. ...
    (microsoft.public.data.ado)
  • Re: Architecture Advice
    ... >> I'm going to be using SQL Server for a distributed ... >> application and I'd appreciate any advice on architecture. ... >> Simplest approach would be 2-tier client server and be done with it. ... it would be nice to be able to provide some data caching at the ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: What do I need to use Terminal Server?
    ... It's taken as offered and all good advice. ... I'm starting to see some major modifications to the overall network setup ... Then, based on what I found in #1, I would order the proper hardware ... and software for you - server, workstations, SQL Server if required, ...
    (microsoft.public.windowsxp.general)
  • Re: Desktop SQL Server
    ... It's also hard to provide you with a better reference because you didn't ... uninstalled when the SQL server is installed. ... Server but, according to my reading on this, the Microsoft Jet Engine ... who runs an application that uses the SQL Server will have to uninstall ...
    (microsoft.public.access.externaldata)
  • Re: Tommy 2W!! (despite car being brken into, computer, IPOD, all CDs, new messenger bag & Con l
    ... I want to repeat your own advice to Tommy to brief his ... for future reference. ... My outlines pissed off all my friends because they were so ... still uses my civ pro outlines ..... ...
    (alt.support.stop-smoking)