in reply to Re^2: Lost connection to MySQL server
in thread Lost connection to MySQL server

Perhaps Neighbour mixed up MySQL and MS-SQL? MS SQL Server's protocol is limited to one active statement handle per connection. (Recent versions add some dirty tricks to overcome this limit, but they require non-portable, specially crafted code.) DBI has no such limits, neither has DBD::ODBC; and I can't find a hint in the documentation of DBD::mysql that it is limited to a single active statement.

Alexander

--
Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)

Replies are listed 'Best First'.
Re^4: Lost connection to MySQL server
by Neighbour (Friar) on Aug 31, 2011 at 06:56 UTC
    You're right..my bad. That's only an issue with MS-SQL which is not what spstansbury is using.
[reply]

In Section Seekers of Perl Wisdom