Re: Generated fields in CE table

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

From: Kevin Collins \(MS - SQL Mobile\) (kevincol_at_online.microsoft.com)
Date: 11/01/04 

Date: Mon, 1 Nov 2004 11:00:37 -0800

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: 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)
  • SQL Server/ADO/XP problem "query cannot be executed"
    ... This is a request for help fixing a SQL Server 2000/ADO problem on Windows ... When I open one of these projects in VB6, the reference to msado27.tlb is ... Most people trying to help are treating it as an installation issue, ...
    (microsoft.public.sqlserver.programming)
  • SQL Server/ADO/XP problem "query cannot be executed"
    ... This is a request for help fixing a SQL Server 2000/ADO problem on Windows ... When I open one of these projects in VB6, the reference to msado27.tlb is ... Most people trying to help are treating it as an installation issue, ...
    (microsoft.public.sqlserver.setup)
  • SQL Server/ADO/XP problem "query cannot be executed"
    ... This is a request for help fixing a SQL Server 2000/ADO problem on Windows ... When I open one of these projects in VB6, the reference to msado27.tlb is ... Most people trying to help are treating it as an installation issue, ...
    (microsoft.public.sqlserver)