Re: Delphi 6 - ADO - MS SQL Server

In article <451404c5$1@xxxxxxxxxxxxxxxxxxxxxx>, gnome@xxxxxxxxx
(AquaGrrlll) wrote:

When I set up the thread I give it it's own TADOConnection as well
as the TADOStoredProc:

Why are you using a thread? You can drive the whole thing with events,
the first event is when the connection to SQL is made, that triggers the
Execute EXEC statements, and ExecuteComplete then triggers any more
Exectutes, until you've finished. This is none blocking, and you can
have several connections to different databases running at the same
time, no threads.

Problem is, that isn't happening. OnExecuteComplete never fires and
the whole thing hangs.

I don't use TADOStoredProc, I just Execute on the connection, checking
Recordset in the event for success. The simpler, the safer.

I'm using these techniques to capture records arriving by multiple TCP
and UDP streams to different database tables, up to 50 records per
second, all in a single thread.

Angus

.

Relevant Pages

  • TAdoStoredProc and Transactions
    ... I have a TAdoStoredProc with a connection that is in a transaction. ... I execute the procedure, and the do a select statement on the updated tables ...
    (borland.public.delphi.database.ado)
  • [Full-Disclosure] Advanced usage of system() function.
    ... and call its arguments as a command for shell. ... as we can see we still didnt get what we want (typing exit ... Connection closed by foreign host. ... think what we want to execute. ...
    (Full-Disclosure)
  • Advanced usage of system() function.
    ... and call its arguments as a command for shell. ... as we can see we still didnt get what we want (typing exit we are ... Connection closed by foreign host. ... think what we want to execute. ...
    (Bugtraq)
  • Re: ADODB Command memory leak
    ... _ConnectionPtr conn = NULL; ... // Execute statement. ... > My logic is such that the connection to the database is not maintained ... Create/Append command parameters ...
    (microsoft.public.data.ado)
  • Re: Script Controlled Dynamic Task Execution
    ... My package had three connections to three ... and each had a transformation for itself. ... After posting, I just created three packages for each connection, and my ... >> need to execute one transformation on a text file, ...
    (microsoft.public.sqlserver.dts)