Yes. In order to run 2 selects at the same time you must open a second connection to the DB and use that second connection for your second select.
Eric
"I'd take you seriously but to do so would be an affront to your intelligence."
-- William F. Buckley --
>From: "Ken Barker" <[EMAIL PROTECTED]>
>To: <ActivePerl@listserv.ActiveState.com>
>Subject: DBD::ODBC
>Date: Tue, 28 Jun 2005 11:46:08 -0500
>MIME-Version: 1.0
>Received: from listserv.activestate.com ([209.17.183.249]) by MC6-F35.hotmail.com with Microsoft SMTPSVC(6.0.3790.211); Tue, 28 Jun 2005 13:33:09 -0700
>Received: from listserv.activestate.com (localhost.localdomain [127.0.0.1])by listserv.activestate.com (8.12.10/8.12.10) with ESMTP id j5SHOboF025987;Tue, 28 Jun 2005 10:25:02 -0700(envelope-from [EMAIL PROTECTED])
>Received: from smtp7.ActiveState.com (percolator.ActiveState.com[192.168.2.13])by listserv.activestate.com (8.12.10/8.12.10) with ESMTP idj5SGi9l2021920 for <ActivePerl@listserv.ActiveState.com>;Tue, 28 Jun 2005 09:44:09 -0700(envelope-from [EMAIL PROTECTED])
>Received: from smtp8.activestate.com (darkroast.activestate.com [192.168.2.82])by smtp7.ActiveState.com (8.12.10/8.12.10) with ESMTP id j5SGi4xS001995for <ActivePerl@listserv.ActiveState.com>;Tue, 28 Jun 2005 09:44:05 -0700 (PDT)(envelope-from [EMAIL PROTECTED])
>Received: from mail.americallgroup.com (mail.americallcorp.net[207.227.21.199] (may be forged))by smtp8.activestate.com (8.13.3/8.13.3) with ESMTP id j5SGi4lo052900for <ActivePerl@listserv.ActiveState.com>;Tue, 28 Jun 2005 09:44:04 -0700 (PDT)(envelope-from [EMAIL PROTECTED])
>X-Message-Info: JGTYoYF78jGHyypm8C6ox6Db7D2mNL9xF+cpX69i9l0=
>Content-Class: urn:content-classes:message
>X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1
>X-MS-Has-Attach:
>X-MS-TNEF-Correlator:
>Thread-Topic: DBD::ODBC
>Thread-Index: AcV8AJa72uSAgifsQ0OMI3vZhrhkrA==
>X-PerlMx-Spam: CA, All, Gauge=IIIIIII, Probability=7%, Report='__C230066_P5 0,__CT 0, __CTE 0, __CTYPE_CHARSET_QUOTED 0, __CT_TEXT_PLAIN 0,__HAS_MSGID 0, __IMS_MSGID 0, __MIME_TEXT_ONLY 0,__MIME_VERSION 0, __SANE_MSGID 0'
>X-PMX-Version: CA 4.7.1.128075, Antispam-Engine: 2.0.3.2,Antispam-Data: 2005.6.28.17
>X-MIME-Autoconverted: from quoted-printable to 8bit bylistserv.activestate.com id j5SGi9l2021920
>X-BeenThere: activeperl@listserv.ActiveState.com
>X-Mailman-Version: 2.1.4
>Precedence: list
>List-Id: Discussions relating to ActivePerl<activeperl.listserv.ActiveState.com>
>List-Unsubscribe: <http://listserv.ActiveState.com/mailman/listinfo/activeperl>, <mailto:[EMAIL PROTECTED]>
>List-Archive: <http://ASPN.ActiveState.com/ASPN/Mail/Browse/Threaded/activeperl>
>List-Post: <mailto:activeperl@listserv.ActiveState.com>
>List-Help: <mailto:[EMAIL PROTECTED]>
>List-Subscribe: <http://listserv.ActiveState.com/mailman/listinfo/activeperl>, <mailto:[EMAIL PROTECTED]>
>Errors-To: [EMAIL PROTECTED]
>Return-Path: [EMAIL PROTECTED]
>X-OriginalArrivalTime: 28 Jun 2005 20:33:09.0863 (UTC) FILETIME=[990F1F70:01C57C20]
>
>I am using the DBD::ODBC driver and whenever I try to run two concurrent statement handles (two separate selects) - I get an error that states the statement handler is busy with another request when it executes the second statement. Is this driver limited to allowing only one statement in use at a time?
>
>
>
>Ken Barker
>IT Lead
>Americall Group, Inc
>314-213-7927
>[EMAIL PROTECTED]
>
>
>_______________________________________________
>ActivePerl mailing list
>ActivePerl@listserv.ActiveState.com
>To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
_______________________________________________ ActivePerl mailing list ActivePerl@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
