I have a database thats got sql as the engine and access 2000 for the client side.Now my problem is every time I edit a record this "Write Conflict" comes up. I did some investigating and I found out its due to a REPLICATIONCONFLICT ERROR.
Can anyone help me plsIs your Access FE running against a database that participates in merge replication? You need to have a serious talk with your DBA about whether you should be developing any app using a db that is already part of another app.|||the only application involved is access 2000, and the network techs are the dba|||what do you mean pls explain FE??sql
Showing posts with label engine. Show all posts
Showing posts with label engine. Show all posts
Wednesday, March 28, 2012
Monday, March 12, 2012
Replication and BDE (Borland Database Engine)
Hi,
Is it true that BDE encounters problem when the database is used for
replication? We have problem with BDE when the tables are used in
publication and rowguid column is added to them. The error message returned
by BDE is not helpful at all (Capability is not supported!)
Any help would be greatly appreciated.
LeilaHi Leila
I believe ROWGUIDCOL is not supported by BDE (although I can't be certain),
but you should not have any need to retrieve/set this. If you do want them
returned try casting it to char/varchar.
John
"Leila" wrote:
> Hi,
> Is it true that BDE encounters problem when the database is used for
> replication? We have problem with BDE when the tables are used in
> publication and rowguid column is added to them. The error message returned
> by BDE is not helpful at all (Capability is not supported!)
> Any help would be greatly appreciated.
> Leila
>
>|||Thanks John,
It seems that BDE performs some queries that is not in your control (when
you work visually with database in Delphi IDE). These queries have problem.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...
> Hi Leila
> I believe ROWGUIDCOL is not supported by BDE (although I can't be
> certain),
> but you should not have any need to retrieve/set this. If you do want them
> returned try casting it to char/varchar.
> John
> "Leila" wrote:
>> Hi,
>> Is it true that BDE encounters problem when the database is used for
>> replication? We have problem with BDE when the tables are used in
>> publication and rowguid column is added to them. The error message
>> returned
>> by BDE is not helpful at all (Capability is not supported!)
>> Any help would be greatly appreciated.
>> Leila
>>|||Hi
Maybe it is time to switch to ADO?
John
"Leila" wrote:
> Thanks John,
> It seems that BDE performs some queries that is not in your control (when
> you work visually with database in Delphi IDE). These queries have problem.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...
> > Hi Leila
> >
> > I believe ROWGUIDCOL is not supported by BDE (although I can't be
> > certain),
> > but you should not have any need to retrieve/set this. If you do want them
> > returned try casting it to char/varchar.
> >
> > John
> >
> > "Leila" wrote:
> >
> >> Hi,
> >> Is it true that BDE encounters problem when the database is used for
> >> replication? We have problem with BDE when the tables are used in
> >> publication and rowguid column is added to them. The error message
> >> returned
> >> by BDE is not helpful at all (Capability is not supported!)
> >> Any help would be greatly appreciated.
> >> Leila
> >>
> >>
> >>
>
>
Is it true that BDE encounters problem when the database is used for
replication? We have problem with BDE when the tables are used in
publication and rowguid column is added to them. The error message returned
by BDE is not helpful at all (Capability is not supported!)
Any help would be greatly appreciated.
LeilaHi Leila
I believe ROWGUIDCOL is not supported by BDE (although I can't be certain),
but you should not have any need to retrieve/set this. If you do want them
returned try casting it to char/varchar.
John
"Leila" wrote:
> Hi,
> Is it true that BDE encounters problem when the database is used for
> replication? We have problem with BDE when the tables are used in
> publication and rowguid column is added to them. The error message returned
> by BDE is not helpful at all (Capability is not supported!)
> Any help would be greatly appreciated.
> Leila
>
>|||Thanks John,
It seems that BDE performs some queries that is not in your control (when
you work visually with database in Delphi IDE). These queries have problem.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...
> Hi Leila
> I believe ROWGUIDCOL is not supported by BDE (although I can't be
> certain),
> but you should not have any need to retrieve/set this. If you do want them
> returned try casting it to char/varchar.
> John
> "Leila" wrote:
>> Hi,
>> Is it true that BDE encounters problem when the database is used for
>> replication? We have problem with BDE when the tables are used in
>> publication and rowguid column is added to them. The error message
>> returned
>> by BDE is not helpful at all (Capability is not supported!)
>> Any help would be greatly appreciated.
>> Leila
>>|||Hi
Maybe it is time to switch to ADO?
John
"Leila" wrote:
> Thanks John,
> It seems that BDE performs some queries that is not in your control (when
> you work visually with database in Delphi IDE). These queries have problem.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...
> > Hi Leila
> >
> > I believe ROWGUIDCOL is not supported by BDE (although I can't be
> > certain),
> > but you should not have any need to retrieve/set this. If you do want them
> > returned try casting it to char/varchar.
> >
> > John
> >
> > "Leila" wrote:
> >
> >> Hi,
> >> Is it true that BDE encounters problem when the database is used for
> >> replication? We have problem with BDE when the tables are used in
> >> publication and rowguid column is added to them. The error message
> >> returned
> >> by BDE is not helpful at all (Capability is not supported!)
> >> Any help would be greatly appreciated.
> >> Leila
> >>
> >>
> >>
>
>
Replication and BDE (Borland Database Engine)
Hi,
Is it true that BDE encounters problem when the database is used for
replication? We have problem with BDE when the tables are used in
publication and rowguid column is added to them. The error message returned
by BDE is not helpful at all (Capability is not supported!)
Any help would be greatly appreciated.
Leila
Hi Leila
I believe ROWGUIDCOL is not supported by BDE (although I can't be certain),
but you should not have any need to retrieve/set this. If you do want them
returned try casting it to char/varchar.
John
"Leila" wrote:
> Hi,
> Is it true that BDE encounters problem when the database is used for
> replication? We have problem with BDE when the tables are used in
> publication and rowguid column is added to them. The error message returned
> by BDE is not helpful at all (Capability is not supported!)
> Any help would be greatly appreciated.
> Leila
>
>
|||Thanks John,
It seems that BDE performs some queries that is not in your control (when
you work visually with database in Delphi IDE). These queries have problem.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...[vbcol=seagreen]
> Hi Leila
> I believe ROWGUIDCOL is not supported by BDE (although I can't be
> certain),
> but you should not have any need to retrieve/set this. If you do want them
> returned try casting it to char/varchar.
> John
> "Leila" wrote:
|||Hi
Maybe it is time to switch to ADO?
John
"Leila" wrote:
> Thanks John,
> It seems that BDE performs some queries that is not in your control (when
> you work visually with database in Delphi IDE). These queries have problem.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...
>
>
Is it true that BDE encounters problem when the database is used for
replication? We have problem with BDE when the tables are used in
publication and rowguid column is added to them. The error message returned
by BDE is not helpful at all (Capability is not supported!)
Any help would be greatly appreciated.
Leila
Hi Leila
I believe ROWGUIDCOL is not supported by BDE (although I can't be certain),
but you should not have any need to retrieve/set this. If you do want them
returned try casting it to char/varchar.
John
"Leila" wrote:
> Hi,
> Is it true that BDE encounters problem when the database is used for
> replication? We have problem with BDE when the tables are used in
> publication and rowguid column is added to them. The error message returned
> by BDE is not helpful at all (Capability is not supported!)
> Any help would be greatly appreciated.
> Leila
>
>
|||Thanks John,
It seems that BDE performs some queries that is not in your control (when
you work visually with database in Delphi IDE). These queries have problem.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...[vbcol=seagreen]
> Hi Leila
> I believe ROWGUIDCOL is not supported by BDE (although I can't be
> certain),
> but you should not have any need to retrieve/set this. If you do want them
> returned try casting it to char/varchar.
> John
> "Leila" wrote:
|||Hi
Maybe it is time to switch to ADO?
John
"Leila" wrote:
> Thanks John,
> It seems that BDE performs some queries that is not in your control (when
> you work visually with database in Delphi IDE). These queries have problem.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...
>
>
Replication and BDE (Borland Database Engine)
Hi,
Is it true that BDE encounters problem when the database is used for
replication? We have problem with BDE when the tables are used in
publication and rowguid column is added to them. The error message returned
by BDE is not helpful at all (Capability is not supported!)
Any help would be greatly appreciated.
Leila
Hi Leila
I believe ROWGUIDCOL is not supported by BDE (although I can't be certain),
but you should not have any need to retrieve/set this. If you do want them
returned try casting it to char/varchar.
John
"Leila" wrote:
> Hi,
> Is it true that BDE encounters problem when the database is used for
> replication? We have problem with BDE when the tables are used in
> publication and rowguid column is added to them. The error message returned
> by BDE is not helpful at all (Capability is not supported!)
> Any help would be greatly appreciated.
> Leila
>
>
|||Thanks John,
It seems that BDE performs some queries that is not in your control (when
you work visually with database in Delphi IDE). These queries have problem.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...[vbcol=seagreen]
> Hi Leila
> I believe ROWGUIDCOL is not supported by BDE (although I can't be
> certain),
> but you should not have any need to retrieve/set this. If you do want them
> returned try casting it to char/varchar.
> John
> "Leila" wrote:
|||Hi
Maybe it is time to switch to ADO?
John
"Leila" wrote:
> Thanks John,
> It seems that BDE performs some queries that is not in your control (when
> you work visually with database in Delphi IDE). These queries have problem.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...
>
>
Is it true that BDE encounters problem when the database is used for
replication? We have problem with BDE when the tables are used in
publication and rowguid column is added to them. The error message returned
by BDE is not helpful at all (Capability is not supported!)
Any help would be greatly appreciated.
Leila
Hi Leila
I believe ROWGUIDCOL is not supported by BDE (although I can't be certain),
but you should not have any need to retrieve/set this. If you do want them
returned try casting it to char/varchar.
John
"Leila" wrote:
> Hi,
> Is it true that BDE encounters problem when the database is used for
> replication? We have problem with BDE when the tables are used in
> publication and rowguid column is added to them. The error message returned
> by BDE is not helpful at all (Capability is not supported!)
> Any help would be greatly appreciated.
> Leila
>
>
|||Thanks John,
It seems that BDE performs some queries that is not in your control (when
you work visually with database in Delphi IDE). These queries have problem.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...[vbcol=seagreen]
> Hi Leila
> I believe ROWGUIDCOL is not supported by BDE (although I can't be
> certain),
> but you should not have any need to retrieve/set this. If you do want them
> returned try casting it to char/varchar.
> John
> "Leila" wrote:
|||Hi
Maybe it is time to switch to ADO?
John
"Leila" wrote:
> Thanks John,
> It seems that BDE performs some queries that is not in your control (when
> you work visually with database in Delphi IDE). These queries have problem.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...
>
>
Replication and BDE (Borland Database Engine)
Hi,
Is it true that BDE encounters problem when the database is used for
replication? We have problem with BDE when the tables are used in
publication and rowguid column is added to them. The error message returned
by BDE is not helpful at all (Capability is not supported!)
Any help would be greatly appreciated.
LeilaHi Leila
I believe ROWGUIDCOL is not supported by BDE (although I can't be certain),
but you should not have any need to retrieve/set this. If you do want them
returned try casting it to char/varchar.
John
"Leila" wrote:
> Hi,
> Is it true that BDE encounters problem when the database is used for
> replication? We have problem with BDE when the tables are used in
> publication and rowguid column is added to them. The error message returne
d
> by BDE is not helpful at all (Capability is not supported!)
> Any help would be greatly appreciated.
> Leila
>
>|||Thanks John,
It seems that BDE performs some queries that is not in your control (when
you work visually with database in Delphi IDE). These queries have problem.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...[vbcol=seagreen]
> Hi Leila
> I believe ROWGUIDCOL is not supported by BDE (although I can't be
> certain),
> but you should not have any need to retrieve/set this. If you do want them
> returned try casting it to char/varchar.
> John
> "Leila" wrote:
>|||Hi
Maybe it is time to switch to ADO?
John
"Leila" wrote:
> Thanks John,
> It seems that BDE performs some queries that is not in your control (when
> you work visually with database in Delphi IDE). These queries have problem
.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...
>
>
Is it true that BDE encounters problem when the database is used for
replication? We have problem with BDE when the tables are used in
publication and rowguid column is added to them. The error message returned
by BDE is not helpful at all (Capability is not supported!)
Any help would be greatly appreciated.
LeilaHi Leila
I believe ROWGUIDCOL is not supported by BDE (although I can't be certain),
but you should not have any need to retrieve/set this. If you do want them
returned try casting it to char/varchar.
John
"Leila" wrote:
> Hi,
> Is it true that BDE encounters problem when the database is used for
> replication? We have problem with BDE when the tables are used in
> publication and rowguid column is added to them. The error message returne
d
> by BDE is not helpful at all (Capability is not supported!)
> Any help would be greatly appreciated.
> Leila
>
>|||Thanks John,
It seems that BDE performs some queries that is not in your control (when
you work visually with database in Delphi IDE). These queries have problem.
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...[vbcol=seagreen]
> Hi Leila
> I believe ROWGUIDCOL is not supported by BDE (although I can't be
> certain),
> but you should not have any need to retrieve/set this. If you do want them
> returned try casting it to char/varchar.
> John
> "Leila" wrote:
>|||Hi
Maybe it is time to switch to ADO?
John
"Leila" wrote:
> Thanks John,
> It seems that BDE performs some queries that is not in your control (when
> you work visually with database in Delphi IDE). These queries have problem
.
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:782B8B52-5D32-4913-8B8A-40FA8C78AAE2@.microsoft.com...
>
>
Subscribe to:
Posts (Atom)