HELP DBI, DBD and mysql [Archive]

View Full Version : HELP DBI, DBD and mysql

Andre Carvalho

03-12-03, 10:40

Hi all,
I have a perl script using DBI, to get data from a sybase and send into a mysql.
The sybase is into a aix unix system, and the mysql is into a windows system.
I have the script into the AIX and so the DBI.
Do I have to install DBD and mysql into AIX? why? (if so)
what about MYODBC can I use it?
thks you all.

thebap

04-08-03, 12:45

Use of most SQL Databases requires DBI as a given.

For Sybase you probably have DBD::Sybase perl module installed

so for MySQL you'll need DBD::MySQL installed to allow access to your MySQL database(s).

Go to the Perl CPAN site and download it onto your AIX system,
use the README to install it and it ought to be pretty similar in theory to
your existing Sybase stuff.

Good Luck.

PS: Yes you could use MyODBC but DBD::MySQL is probably better for your situation.