"Javier Villegas" <mask@impsat1.com.ar> wrote in message
news:yO6ha.81744$rJ3.35069@fe10.atl2.webusenet.com...
> Problem with VB6 App & SQL 2000 (Locking & lost transactions)
>
> Hi,
>
> We are having a big, big problem with our OLTP system.
>
> We have a VB6 App. that receive transactions (TX) via Winsock from an
> Access Server (NAC) that comes from Points-of-sales (POS)
>
>
> The VB 6 App receive the packet, then pharses it and fill a lot of
variable.
> Then the App call a stored procedure (With ADO) called t_recepcion whith
> aprox. 10 parameters (That are form the pharse proccess) and the sp
receive
> the results as output parameters. Finally the App build the response
packet
> and send it to the POS by Winsock Again.
>
> This sp (t_recepcion) call another sp for resolve the transaction.
>
> There are 15000 transactions per day
>
> Well, the problem is that we are losing transactions from the database
that
> were responded by the system (The people that
> made the transaction had the ticket printed)
>
> I don´t know how can I make the BEGIN - COMMIT for have the highest
> isolation level for each transaction. or if I must change something in the
> SQL Engine
>
> When one transaction come to the App and hang, the App continue responding
> transactions but in some cases I must close the App. Then the system make
a
> ROLLBACK to this hanged transaction (Losing the transactions that were
> responsed after the hang)
>
> I don´t know if you understand my problem (My English is not good, and I
am
> not the developer)
>
> But I need to solve this tremendous problem
>
> If you could solve it , you are very welcome. if not, tell me if you have
> some tips for do this
>
> Thanks in Advance
>
> Javier
> mask@impsat1.com.ar
>
>
>
>
>
>
>
>