I have been using DBI for several years, and have a fairly extensive group
of programs that relay on DBI to connect to a database and extract data.
All my programs use a common library of functions that includes a function
which connects to the database:
$dsn = 'dbi:ODBC:prod1' ;
$user = 'user' ;
$passwd = 'XXXXXXXX' ;
$dbh = DBI->connect($dsn, $user, $passwd,
{RaiseError => 1, AutoCommit => 0})
or die "Could not connect to database: " . DBI->errstr ;
This has worked for years, but yesterday, it suddenly stopped working. Now
my programs get to this function, and stop. No error messages are
generated, and the database logs do not show a connection attempt, failed
or otherwise.
The database itself is an odd thing that I don't expect folks to be
familiar with. We use Relativity, which allows CISAM flat files to be used
like a relational database. There have not been recent changes to
Relativity, and I can see that other (non-Perl) applications are accessing
the database without any issues. So the problem seems to be isolated to
Perl programs attempting to connect to this database.
I am not sure what to do to gather more information about this issue. I
wrote s test program to isolate the DBI->connect method, and gather
information. I am able to list the available drivers: Proxy, Sponge, DBM,
ExampleP, File, ODBC, but I'm not sure what else I can do.
I would appreciate any suggestions about how to gather more information or
resolve this issue.
