ClientDataset with TADODataSet

From: Avi Minsky (minsky.a_at_gmail.com)
Date: 10/25/04 

Date: 25 Oct 2004 01:52:36 -0700

Hello
Delphi 7.
In the last few days i tried to understand why i get the message
"Cannot create new connection in manual or distributed transaction
mode"
i had an ADOConnection and a TAdoDataset with Cursor location on
server side and ForwardOnly.

It seems that the TAdoDataSet made everything not work as good, and
when i switched it to TAdoQuery it started working.

I hope that will solve people problems

Relevant Pages

  • Re: How do I capture Delphi 5 TADODataset timeout error consistently?
    ... When I run a query that executes a stored procedure, ... If I just run straight SQL text that returns a large dataset, ... > I am using Delphi 5, hitting a SQL Server 2000 database. ... > I have a simple reporting application that uses a TADODataset to run ...
    (borland.public.delphi.database.ado)
  • Re: How to copy a memo
    ... With tADODataset it's not possible tu use a ... Willi ... >>another table, in another connection. ...
    (borland.public.delphi.database.ado)
  • Updating with TADODataSet
    ... I am converting from Paradox in Delphi 6 to Microsoft SQL. ... TADODataSet to get a subset of data for a grid, ...
    (borland.public.delphi.database.ado)
  • Re: ADOQuery vs. ADODataSet
    ... > TADODataSet directly in Delphi, maybe because I was a BDE user. ... > What is the positive side of using TADODataSets instead of TADOQueries?. ... "'Serious' ADO Speed Techniques With Delphi - Part 1" ...
    (borland.public.delphi.database.ado)
  • Re: CommandTimeout - TDataSetProvider/TADOQuery
    ... No you will have to update your version of Delphi to get that fixed. ... TADODataset is a better component to use than TadoQuery ... Brian Bushay ...
    (borland.public.delphi.database.ado)