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]

Reply via email to