Webmaster Forum / Perl / DBI Library / June 2005

   Trying to connect to a MySQL database from a Linux Server using
PERL to a Windows Machine with a MySQL database (5.0.6). I can
connect successfully on the windows box but cannot on the Linux
server! I ran a SQLTRACE (DBD) with the following output:

Thanks for your help.
This is Larry Li from Toronto. I am trying to install DBI on AIX 5.2. I
am facing the following failure.
Step 1: seems it succeeded.

I must be doing something wrong or there has to be a better way?
I have compiled the dbi module it some how sucks in the path for the
oracle libclntsh.so.8.0 and now when ever we move our database to another
server I have to recompile or I get the following:

This may sound trivial...but I've been trying to find out how to find
the largest primary key that's been assigned/used within a table.
I'm new to DB development while I have done some DBA.
It would save me trouble when I want to keep control of the primary

Looks like the wiki has been vandalized. At least the home page:
<http://wiki.class-dbi.com/index.cgi?HomePage>
Is there a backup?
Regards,

Six months ago, I was asked to install Oracle 9.2.0.6 client and perl with
DBI/DBD. It was ever so easy!
Two days, I was asked to repeat the exercise again on another server. Using
the same Perl, Oracle, DBI and DBD-Oracle sources I have problems with the

Does dbi provide asynchronous calls? If not, what perl module is there
that supports asynchronous sql query calls to the database - meaning, I
don't have to wait for the call to return. I am using mysql.
Thanks,

I found this page:
http://ftp.esoftmatic.com/DBI/
but the DBI.ppd there seems to be an empty HTML page.  I've just
downloaded ActiveState for Windows and it doesn't come with DBI...

Hey all,
Is there any way to get a Class::DBI connection to pass
Exception::Class::DBI ->handler as DBI->Connect()'s HandleError
argument?

If I get all my columns with $class->columns, is there a way to find out
what data type each column has (not depending on dbms)?
Marc

The DBD::Sybase tests fail rather gruesomely if they can't connect to
the database.  This patch adds a bit more error checking to fail more
cleanly in some cases where a database connection couldn't be opened or
a statement prepared.

Hey all,
I'm doing my first foray into Class::DBI here, and I'm getting a
compile error.  I've placed a tarball of a dump of my database
structure, my MailDB::DBI-related modules and a test script called

Hi list!
After starting to use CDBI I defined all my packages in one file.
Now I thought it would be memory conservative and 'better' to split them
up into one file per package definition.

Attached is a patch I'm using for Ima::DBI which makes all the stuff on
the wiki's mod_perl page unnecessary.  This is for mod_perl 1, but I can
expand it to mod_perl 2 (or someone else can) if it seems likely this
patch will get incorporated into Ima::DBI.  The other option would ...

Hi,
I have been using DBD::Sybase to execute stored procedures on a
remote SQL server and it worked great for some time.
However, it stopped working for recent builds of our software. I do