> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
>
> I have two questions. First, where can I find the possible error
> strings that $DBI::errstr might contain?
You will have to look in (at least) three places:
1) the DBI documentation (and probably also the code) to see
the error messages (if any) that the DBI can raise
2) the documentation (and also the code) for the DBD driver
that you use.
3) The documentation (and preferably also the code, but that
might be a tad more difficult to find) for the database
system that you use.
There is no simple answer.
>
> Second, when a connection to a database is made via DBI->connect(..),
> how long will that connection stay open? Does it matter if the
> database is on the same machine or on a separate machine from the DBI
> application?
>
It will stay open until you $dbh->disconnect it (or something
terrible happens to either your programme or the database system :).
It doesn't matter if it is on the samme or another machine (or on
another planet for that matter).
Henrik