Oeschey, Lars (I/EK-142, extern) <> wrote:
> Hi,
>
> I'm trying to do a database fetch on one table, and an insert on
> another table on the same DB. This looks like this:
>
> $mssth=$msdbh->prepare("SELECT * FROM SyncroTess_in"); if
> ($mssth->execute) { while (my @getdata=$mssth->fetchrow_array) {
> .....
> ......
> $msdbh->do("INSERT INTO SyncroTess_out Pakete, Ladestelle, AKNr,
> time VALUES ('$einzelpaket','$ladestelle','$aknr','$now'");
> ....
> ....
>
> and I get this error:
>
> Tue Nov 20 14:55:51 2007 DBD::ODBC::db do failed: [Microsoft][ODBC
> SQL Server Driver]Die Verbindung ist mit Ergebnissen von einem
> anderen hstmt belegt (SQL-HY000)(DBD: Execute immediate failed
> err=-1) at soappush.pl line 35.
>
> (i.e. handle is in use)
It looks like you are trying to execute a new statement handle while
fetching data from another statement handle associated with the same
database handle, on an SQL Server database via ODBC. According to the
book "Programming the Perl DBI" the ODBC drivers will not let you do
this.
>
> how can I workaround this?
Creating another database handle might do the trick. If not, you will
have to delay your inserts until the fetch loop has finished.
HTH
--
Brian Raven
=========================================
Atos Euronext Market Solutions Disclaimer
=========================================
The information contained in this e-mail is confidential and solely for the
intended addressee(s). Unauthorised reproduction, disclosure, modification,
and/or distribution of this email may be unlawful.
If you have received this email in error, please notify the sender immediately
and delete it from your system. The views expressed in this message do not
necessarily reflect those of Atos Euronext Market Solutions.
Atos Euronext Market Solutions Limited - Registered in England & Wales with
registration no. 3962327. Registered office address at 25 Bank Street London
E14 5NQ United Kingdom.
Atos Euronext Market Solutions SAS - Registered in France with registration no.
425 100 294. Registered office address at 6/8 Boulevard Haussmann 75009 Paris
France.
L'information contenue dans cet e-mail est confidentielle et uniquement
destinee a la (aux) personnes a laquelle (auxquelle(s)) elle est adressee.
Toute copie, publication ou diffusion de cet email est interdite. Si cet e-mail
vous parvient par erreur, nous vous prions de bien vouloir prevenir
l'expediteur immediatement et d'effacer le e-mail et annexes jointes de votre
systeme. Le contenu de ce message electronique ne represente pas necessairement
la position ou le point de vue d'Atos Euronext Market Solutions.
Atos Euronext Market Solutions Limited Société de droit anglais, enregistrée au
Royaume Uni sous le numéro 3962327, dont le siège social se situe 25 Bank
Street E14 5NQ Londres Royaume Uni.
Atos Euronext Market Solutions SAS, société par actions simplifiée, enregistré
au registre dui commerce et des sociétés sous le numéro 425 100 294 RCS Paris
et dont le siège social se situe 6/8 Boulevard Haussmann 75009 Paris France.
=========================================
_______________________________________________
ActivePerl mailing list
ActivePerl@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
