Re: Problems connecting
"Albert E. Whale" <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Organization | ABS Computer Technology, Inc. |
| Message-ID | <[email protected]> |
Martin J. Evans wrote: > The error "disconnect invalidates 1 active statement handle" implies > you have an active statement for which all results have not been fetched > when you call disconnect. e.g. > > prepare(some sql) > execute > fetch one row when there are 20 rows > disconnect (or script terminates) > > As the error states, if you don't fetch all the results from a select > then call finish first or fetch all the results. > > I cannot tell from your description how "this works on one server" > and not another. > > Martin > Thank you. Perhaps there is more than one record which has been duplicated in one DB, and not in another. I'll start there. Thanks for the information!! -- Albert E. Whale, CHS CISA CISSP Sr. Security, Network, Risk Assessment and Systems Consultant ------------------------------------------------------------------- ABS Computer Technology, Inc. - www.ABS-CompTech.com SPAM Zapper - No-JunkMail.com - Spam-Zapper.com - SPAM Stops Here. -- MySQL Perl Mailing List For list archives: http://lists.mysql.com/perl To unsubscribe: http://lists.mysql.com/[email protected]