I've encountered this problem before while using DBD::ODBC. It usually is
how I am dealing with the results of a previous query. The way to handle it
is to open another connection. Works fine like that.
Steve Howard
-----Original Message-----
From: Michael Peppler [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 11:59 AM
To: [EMAIL PROTECTED]
Subject: Re: Connection is busy
roberto l writes:
> And since this is dependant on the protocol changing the odbc driver
won't work. So
> what would be the best workaround?
Depends.
I think some ODBC drivers have support for this "under the covers",
possibly by opening a second connection for you. I don't know much
about ODBC, unfortunately.
DBD::Sybase gets around the problem (not very nicely) by opening a new
connection for the sth if the dbh already has an active sth.
Michael
> Michael Peppler wrote:
>
> > Sterin, Ilya writes:
> > > I would imaging that that is either the SQLServer config or ODBD
config that
> > > is not allowing multiple connections.
> >
> > Actually it's not allowing multiple statement handlers on the same
> > connection. This is the default for the TDS protocol (the underlying
> > protocol that MS-SQL and Sybase use to communicate between the client
> > and the server.)
> >
> > Michael
> >
> > > -----Original Message-----
> > > From: roberto l
> > > To: [EMAIL PROTECTED]
> > > Sent: 05/17/2001 10:03 AM
> > > Subject: Connection is busy
> > >
> > > We've recently ported an application from MSaccess to SQL Server 7
and
> > > now many programs are failing producing the following error:
> > >
> > > [Microsoft][ODBC SQL Server Driver]
> > > Connection is busy with results for another hstmt
> > > (SQL-S1000)(DBD: st_execute/SQLExecute err=-1)
> > >
> > > Should I use another ODBC driver?
> > >
> > > Any suggestion will be greatly appreciated. The platform: perl
5.6.0, nt
> > > 4.0 sp 6 and sql server 7.
> > >
> > > bests
> > >
> > >
> > >
> > >
> > > --
> > > De duobus malis, minus est semper eligendum
> > >
> >
> > --
> > Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED]
> > http://www.mbay.net/~mpeppler - [EMAIL PROTECTED]
> > International Sybase User Group - http://www.isug.com
> > Sybase on Linux mailing list: [EMAIL PROTECTED]
>
> --
> De duobus malis, minus est semper eligendum
>
>
--
Michael Peppler - Data Migrations Inc. - [EMAIL PROTECTED]
http://www.mbay.net/~mpeppler - [EMAIL PROTECTED]
International Sybase User Group - http://www.isug.com
Sybase on Linux mailing list: [EMAIL PROTECTED]
