Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

Answer: Two connections are unnecessary

by mosiondz (Acolyte)
on May 18, 2000 at 22:15 UTC ( #13078=categorized answer: print w/replies, xml ) Need Help??

Q&A > database programming > Are 2 database connections neccesary w/DBI? - Answer contributed by mosiondz

You should not have to start up a second DBI connection. All that should be required is as follows:
# set DB and SQL values as necessary use DBI; $dbh = DBI->connect "$DB_SERVER:$DB_NAME;$DB_HOST") or die "Can't conn +ect to $DB_NAME, error "; $sth = $ccmd_auth::dbh->prepare($sql) or die "Can't prepare $sql: $dbh +->errstr\n"; $sth->execute; $sth->finish;

After the $sth is 'finished', you should be able to prepare and use $sth again in other queries.

One thing I noticed in your code is that you refer to a $dbh2 when you set up your second $sth. Is this for a connection to a second database? Otherwise it should use the same $dbh that was originally set up. This may be what is causing your problem.

Log In?

What's my password?
Create A New User
[atcroft]: Discipulus: I looked back at your note about my Padre question from a while back, and it made me look again... as a result, I found what I was missing and was able to make the change. Thank you!

How do I use this? | Other CB clients
Other Users?
Others exploiting the Monastery: (7)
As of 2018-02-24 20:27 GMT
Find Nodes?
    Voting Booth?
    When it is dark outside I am happiest to see ...

    Results (311 votes). Check out past polls.