Connection is busy with results for another hstmt

I have my java based application that works fine with SQL
server 6.5.
I upgraded DB to SQL Server 2000 and now the application
give me "Connection is busy with results for another
hstmt " ODBC error after I do couple of queries or updates
through the application.
Is it anything to do with ODBC drivers or I have to change
setup of SQL Server?
Thank you
Athar
SQL Server only supports a single active statement per connection. Are you
using the MS JDBC driver to access SQL Server?
If you aren't actually trying to use multiple statements per connection,
then you might be able to workaround the error by making sure the statement
is closed before using another one. I'm not familiar with the JDBC
interface, but in ODBC, you'd call SQLMoreResults() until it returned
SQL_NO_DATA to make sure you've processed all of the results on the wire.
In ADO.NET you will get the same error if you haven't called Close() or
Dispose() on the SqlDataReader before trying to Execute another SqlCommand
on the same SqlConnection.
If you are trying to use multiple statements per connection (at the same
time), then you need to use multiple connections instead.
SQL Server 2005 has a new feature called MARS (Multiple Active Result Sets)
which will allow multiple statements per connection.
Brannon
"Athar" <aikram@.celestica.com> wrote in message
news:185a01c47bdf$ee142e80$a601280a@.phx.gbl...
> I have my java based application that works fine with SQL
> server 6.5.
> I upgraded DB to SQL Server 2000 and now the application
> give me "Connection is busy with results for another
> hstmt " ODBC error after I do couple of queries or updates
> through the application.
> Is it anything to do with ODBC drivers or I have to change
> setup of SQL Server?
> Thank you
> Athar

Connection is busy with results for another hstmt

I have my Java based application that works fine with SQL
server 6.5.
I upgraded DB to SQL Server 2000 and now the application
give me "Connection is busy with results for another
hstmt " ODBC error after I do couple of queries or updates
through the application.
Is it anything to do with ODBC drivers or I have to change
setup of SQL Server?
Thank you
AtharSQL Server only supports a single active statement per connection. Are you
using the MS JDBC driver to access SQL Server?
If you aren't actually trying to use multiple statements per connection,
then you might be able to workaround the error by making sure the statement
is closed before using another one. I'm not familiar with the JDBC
interface, but in ODBC, you'd call SQLMoreResults() until it returned
SQL_NO_DATA to make sure you've processed all of the results on the wire.
In ADO.NET you will get the same error if you haven't called Close() or
Dispose() on the SqlDataReader before trying to Execute another SqlCommand
on the same SqlConnection.
If you are trying to use multiple statements per connection (at the same
time), then you need to use multiple connections instead.
SQL Server 2005 has a new feature called MARS (Multiple Active Result Sets)
which will allow multiple statements per connection.
Brannon
"Athar" <aikram@.celestica.com> wrote in message
news:185a01c47bdf$ee142e80$a601280a@.phx.gbl...
> I have my Java based application that works fine with SQL
> server 6.5.
> I upgraded DB to SQL Server 2000 and now the application
> give me "Connection is busy with results for another
> hstmt " ODBC error after I do couple of queries or updates
> through the application.
> Is it anything to do with ODBC drivers or I have to change
> setup of SQL Server?
> Thank you
> Athar

Connection designer in RS 2005?

I have upgraded our Custom Data Extension from SQL 2000 Reporting Services
to 2005. I see that the Report Wizard will now launch my Query Designer for
editing command strings (thank you!) but I still can not see a way to get RS
to launch my "Connection Designer" dialog. When running Report Wizard or
Add New Data Source dialog, the "Edit" button becomes greyed out when I
change the Data Source Type to my Provider. How can I plug my Connection
String editor user interface at this point?
Thanks!Hello Stephen,
This is a quick note that I am consulting in the internal discussion group
to discuss this issue. I appreciate your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Any update on this issue?
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> wrote in message
news:an29mv$yGHA.3392@.TK2MSFTNGXA01.phx.gbl...
> Hello Stephen,
> This is a quick note that I am consulting in the internal discussion group
> to discuss this issue. I appreciate your patience.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
>|||Hello Stephen,
Sorry Stephen, I did not get update from the discussion group, I am still
performing research now. Thank you for your patience.
Sincerely,
Wei Lu
Microsoft Online Community Support|||Hello Stephen,
How are you doing on this issue? I'm posting to inform you that we're still
focus on this issue, since Wei is absent due to some urgent issue, he'll
udpate you when he get any update from product team later.
Meanwhile, if you have any further questions or concerns, please feel free
to post here.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
This posting is provided "AS IS" with no warranties, and confers no rights.|||I look forward to the resolution of this importan issue. Thansk for staying
on top of it.
"Steven Cheng[MSFT]" <stcheng@.online.microsoft.com> wrote in message
news:ArAs09k1GHA.4464@.TK2MSFTNGXA01.phx.gbl...
> Hello Stephen,
> How are you doing on this issue? I'm posting to inform you that we're
> still
> focus on this issue, since Wei is absent due to some urgent issue, he'll
> udpate you when he get any update from product team later.
> Meanwhile, if you have any further questions or concerns, please feel free
> to post here.
> Sincerely,
> Steven Cheng
> Microsoft MSDN Online Support Lead
>
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>|||Hello Stephen,
Unfortunately, I got the response from the product team that Report
Designer does not support customer-written connection string editors at
this time.
I also contact to them that whether this feature is under consideration. So
far, I do not get the feedback on this.
If I get any information, I will update you ASAP.
Sincerely,
Wei Lu
Microsoft Online Community Support|||Hello,
From the feedback of product team, they will add this to their list of
potential considerations.
For now, if you have any concerns, please feel free to send your feedback
to product team:
http://connect.microsoft.com/SQLServer.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Connection count gone wild after upgrade to SQL2k5!

We upgraded our server last week to SQL 2005. Prior to this on SQL2k we
averaged 100 connections to the server from our web servers and in-house
applications. All we did was update our application config files so the
connection strings pointed at the new server and now we are up to over
5000!!!!! connections. All of our connection strings are either at the
default max connections or lowered to 50-75. We only have 2 web servers
hitting this SQL box and probably a couple dozen workstations running
windows apps in a very subdued manner, i.e. not db intensive at all.
How could this happen? I'm tempted to alter the server config and force a
max# connections but I'm worried what will happen if I do.
Any input/ideas?How do you count the number of connections?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
news:%23VDKUMIoGHA.4800@.TK2MSFTNGP04.phx.gbl...
> We upgraded our server last week to SQL 2005. Prior to this on SQL2k we
> averaged 100 connections to the server from our web servers and in-house
> applications. All we did was update our application config files so the
> connection strings pointed at the new server and now we are up to over
> 5000!!!!! connections. All of our connection strings are either at the
> default max connections or lowered to 50-75. We only have 2 web servers
> hitting this SQL box and probably a couple dozen workstations running
> windows apps in a very subdued manner, i.e. not db intensive at all.
> How could this happen? I'm tempted to alter the server config and force a
> max# connections but I'm worried what will happen if I do.
> Any input/ideas?
>|||Perfmon - SQLServer:General Statistics -> User Connections
"Remus Rusanu [MSFT]" <remus.rusanu@.online.microsoft.com> wrote in message
news:uBVNBWIoGHA.3532@.TK2MSFTNGP04.phx.gbl...
> How do you count the number of connections?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> HTH,
> ~ Remus Rusanu
> SQL Service Broker
> http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
> "Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
> news:%23VDKUMIoGHA.4800@.TK2MSFTNGP04.phx.gbl...
>> We upgraded our server last week to SQL 2005. Prior to this on SQL2k we
>> averaged 100 connections to the server from our web servers and in-house
>> applications. All we did was update our application config files so the
>> connection strings pointed at the new server and now we are up to over
>> 5000!!!!! connections. All of our connection strings are either at the
>> default max connections or lowered to 50-75. We only have 2 web servers
>> hitting this SQL box and probably a couple dozen workstations running
>> windows apps in a very subdued manner, i.e. not db intensive at all.
>> How could this happen? I'm tempted to alter the server config and force
>> a max# connections but I'm worried what will happen if I do.
>> Any input/ideas?
>|||Are you using Service Broker activation by any chance? This would include
also features like SqlDependency or Web pages SqlCacheDependency that are
using activation behind the scenes. Activation can cause the perf counter to
go to abnormaly high values, but is only a perfcounter issue (is not
decremented properly).
You can confirm if the connections really grow or is just the a counter
problem by using a management view, like sys.dm_exec_connections.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
news:O8JnogIoGHA.4728@.TK2MSFTNGP03.phx.gbl...
> Perfmon - SQLServer:General Statistics -> User Connections
> "Remus Rusanu [MSFT]" <remus.rusanu@.online.microsoft.com> wrote in message
> news:uBVNBWIoGHA.3532@.TK2MSFTNGP04.phx.gbl...
>> How do you count the number of connections?
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> HTH,
>> ~ Remus Rusanu
>> SQL Service Broker
>> http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
>> "Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
>> news:%23VDKUMIoGHA.4800@.TK2MSFTNGP04.phx.gbl...
>> We upgraded our server last week to SQL 2005. Prior to this on SQL2k we
>> averaged 100 connections to the server from our web servers and in-house
>> applications. All we did was update our application config files so the
>> connection strings pointed at the new server and now we are up to over
>> 5000!!!!! connections. All of our connection strings are either at the
>> default max connections or lowered to 50-75. We only have 2 web servers
>> hitting this SQL box and probably a couple dozen workstations running
>> windows apps in a very subdued manner, i.e. not db intensive at all.
>> How could this happen? I'm tempted to alter the server config and force
>> a max# connections but I'm worried what will happen if I do.
>> Any input/ideas?
>>
>

Connection count gone wild after upgrade to SQL2k5!

We upgraded our server last week to SQL 2005. Prior to this on SQL2k we
averaged 100 connections to the server from our web servers and in-house
applications. All we did was update our application config files so the
connection strings pointed at the new server and now we are up to over
5000!!!!! connections. All of our connection strings are either at the
default max connections or lowered to 50-75. We only have 2 web servers
hitting this SQL box and probably a couple dozen workstations running
windows apps in a very subdued manner, i.e. not db intensive at all.
How could this happen? I'm tempted to alter the server config and force a
max# connections but I'm worried what will happen if I do.
Any input/ideas?How do you count the number of connections?
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
news:%23VDKUMIoGHA.4800@.TK2MSFTNGP04.phx.gbl...
> We upgraded our server last week to SQL 2005. Prior to this on SQL2k we
> averaged 100 connections to the server from our web servers and in-house
> applications. All we did was update our application config files so the
> connection strings pointed at the new server and now we are up to over
> 5000!!!!! connections. All of our connection strings are either at the
> default max connections or lowered to 50-75. We only have 2 web servers
> hitting this SQL box and probably a couple dozen workstations running
> windows apps in a very subdued manner, i.e. not db intensive at all.
> How could this happen? I'm tempted to alter the server config and force a
> max# connections but I'm worried what will happen if I do.
> Any input/ideas?
>|||Perfmon - SQLServer:General Statistics -> User Connections
"Remus Rusanu [MSFT]" <remus.rusanu@.online.microsoft.com> wrote in messa
ge
news:uBVNBWIoGHA.3532@.TK2MSFTNGP04.phx.gbl...
> How do you count the number of connections?
> --
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
> HTH,
> ~ Remus Rusanu
> SQL Service Broker
> http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
> "Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
> news:%23VDKUMIoGHA.4800@.TK2MSFTNGP04.phx.gbl...
>|||Are you using Service Broker activation by any chance? This would include
also features like SqlDependency or Web pages SqlCacheDependency that are
using activation behind the scenes. Activation can cause the perf counter to
go to abnormaly high values, but is only a perfcounter issue (is not
decremented properly).
You can confirm if the connections really grow or is just the a counter
problem by using a management view, like sys.dm_exec_connections.
This posting is provided "AS IS" with no warranties, and confers no rights.
HTH,
~ Remus Rusanu
SQL Service Broker
http://msdn2.microsoft.com/en-us/library/ms166043(en-US,SQL.90).aspx
"Tim Greenwood" <tim_greenwood A-T yahoo D-O-T com> wrote in message
news:O8JnogIoGHA.4728@.TK2MSFTNGP03.phx.gbl...
> Perfmon - SQLServer:General Statistics -> User Connections
> "Remus Rusanu [MSFT]" <remus.rusanu@.online.microsoft.com> wrote in mes
sage
> news:uBVNBWIoGHA.3532@.TK2MSFTNGP04.phx.gbl...
>