It is a limitation of SQL Server that it can only have a single active statement on a connection. Many other databases will support multiple active statements on the same connection.

You will need to rewrite your code to get around the limitation. I have usually seen this limitation when looping over the results of one query and performing another query on each row. One solution is to pull all the data into memory instead of looping over each element of the results. Another is to use a second connection for the second statements.

DBI will automatically finish the statement when all the results have been read. If you aren't reading all the results from a query, then you will need to call $sth->finish() manually. There are convienence function like selectrow_hashref.

---

---

Posts are HTML formatted. Put <p> </p> tags around your paragraphs. Put <code> </code> tags around your code and data!

Titles consisting of a single word are discouraged, and in most cases are disallowed outright.

Read Where should I post X? if you're not absolutely sure you're posting in the right place.

Please read these before you post! —

• How do I compose an effective node title?
• How do I post a question effectively?
• Markup in the Monastery

Posts may use any of the Perl Monks Approved HTML tags:

a, abbr, b, big, blockquote, br, caption, center, col, colgroup, dd, del, details, div, dl, dt, em, font, h1, h2, h3, h4, h5, h6, hr, i, ins, li, ol, p, pre, readmore, small, span, spoiler, strike, strong, sub, summary, sup, table, tbody, td, tfoot, th, thead, tr, tt, u, ul, wbr

You may need to use entities for some characters, as follows. (Exception: Within code tags, you can put the characters literally.)

	For:		Use:
	&		&
	<		&lt;
	>		&gt;
	[		&#91;
	]		&#93;

Link using PerlMonks shortcuts! What shortcuts can I use for linking?

See Writeup Formatting Tips and other pages linked from there for more info.