Paul
This is an endemic MS SQL ODBC Problem, It is solved (sort of) in ADO
which adds connections as required (this of course chews up connections)
Have you considered ADO Express? I'd suggest Client side/Static Cursor
Datasets
as being the most reliable
HTH
Neven
----- Original Message -----
From: "Paul Mostek" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Thursday, September 13, 2001 9:24 AM
Subject: [DUG]: Interbase X SQL Server
> Hello all,
> This is my debut in [EMAIL PROTECTED] !
> Although the yesterday disaster, I have to work...
> And unfortunately I have a very serious problem on
> my work:
>
> I work maintaining and raising a big system
> developed in Delphi 4 Client/Server.
> This system was made by another person to work with an
> Interbase 5.1.1 Server.
> With Interbase, the system works superbly. But due to
> politics reasons, my boss is demanding me
> to use MS SQL Server 7...
> My problem begins at this point. The system was
> designed with several TQueries with the
> RequestLive property set to TRUE.
> There are numerous TQueries e DBGrids attached to
> those TQueries. The data handling is made
> entirely through the DBGrids (insertion, deletion,
> update).
> When the system is running over MS SQL Server 7 the
> following error happens :
> "Key Violation
> General SQL error.
> [Microsoft][ODBC SQL Server Driver] Connection
> is busy with results for another hstmt."
> This error is intermittent: sometimes happens,
> sometimes doesn4t happens.
>
> I4ve searched for this error message in the
> Microsoft TechNet and found a brief explanation in
> http://support.microsoft.com/support/kb/articles/Q143/0/32.asp.
> They say, the following:
> "After you execute an asynchronous query you
> cannot access the recordset or execute another
> asynchronous query on the same RdoConnection until the
> StillExecuting property of the recordset
> is False. This behavior is by design."
> Well, Microsoft obviously is referring to a
> Visual Basic point of view when talk about
> StillExecuting. And I4m absolutely sure that there are
> not concurrent queries being executed in
> the system.
> Surely the error happens when opening a query
> with RequestLive=True. Then me and my
> development team are transforming drastically the
> system to eliminate the use of
> RequestLive=True.
> But, as the system is very huge, the amount of
> effort is enormous. Then I4ve tried to access
> the MS SQL Server 7 through a MSSQL native driver in
> BDE, instead of use ODBC. Unexpectedly
> another kind of error happens:
> "General SQL error.
> Syntax error converting datetime from
> character string."
> The most weird thing is that this error happens
> even when I am altering data on the SQL
> Explorer 4.
> Then I4ve only changed from an error to
> another...
> I4ve sent the command SET DATEFORMAT DMY do MS
> SQL Server, but the problem continues.
>
>
> Do you have some idea to solve this problem ?
> Do you have some alternative to avoid the hard
> task of modifing the whole system ?
>
> Thanks a lot.
> Forgive-me whether I was very prolix...
>
> Paul Mostek
>
>
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
> Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
