Re^3: Can i execute two queries connecting to same DB at a time.

Below is the my code my ( $data_source, $user_id, $password ) = qw( PHOENIX DBADMIN DBADMIN ); my $conn_string = "driver={SQL Server};Server=$data_source;Database=$database;UID=$user_id;PWD=$password"; my $dbh = DBI->connect( "DBI:ODBC:$conn_string" ) or die $DBI::errstr; my $sql1 = "SELECT CONTENT_HASH FROM DS_STAGING_CONTENTHASH where STAGING_STATUS_GID!=210"; my $sth = $dbh->prepare( $sql1 ); $sth->execute; In this i executed only one query (above code works fine). But when i try to execute another query by my $sql2 = "SELECT CASESHARE_PATH FROM DS_CASESHARE"; my $sth2 = $dbh->prepare( $sql2 ); $sth2->execute; This gives error as i mentioned above

Comment on Re^3: Can i execute two queries connecting to same DB at a time.

Replies are listed 'Best First'.
Re^4: Can i execute two queries connecting to same DB at a time. by Corion (Patriarch) on May 07, 2009 at 07:02 UTC
What part of `Connection is busy with result` and my reply: you still have a statement handle open and did not ->finish() it before trying to issue another SQL statement is giving you problems? Your code is opening a second SQL statement before retrieving all results from the first SQL statement. This does not work for your combination of database, OS and DBD.	[reply] [d/l]
Re^4: Can i execute two queries connecting to same DB at a time. by afoken (Chancellor) on May 07, 2009 at 07:00 UTC
Please use <code> tags, this is unreadable. And read what I wrote about the protocol issue just five minutes ago. Alexander -- Today I will gladly share my knowledge and experience, for there are no sweeter words than "I told you so". ;-)	[reply]