Mar 17, 2004, 2:50 PM
Post #4 of 4
Well looking at the logs explained everything and then talking to the person who initially gave me the host name information was not correct.
Re: [peterhawkes] Attempted database (mysql) connection brings up a blank screen
[In reply to]
it was bosco.seanet.com
but this information made little difference as looking in the log, their server does not support Perl->DBI applications.
Can't locate object method "connect" via package "DBI" at databaseconnectionmethod2.pl line 16.
install_driver(mysql) failed: Can't load '/usr/libdata/perl5/site_perl/i386-bsdos/auto/DBD/mysql/mysql.so' for module DBD::mysql: File not found at /usr/libdata/perl5/5.00503/i386-bsdos/DynaLoader.pm line 169.
I'm a bit disgruntled by this. I knew my code was fine...above was just a snippet of the larger code. Originally I used an MSAccess ODBC connection on my local webserver at home, but FTP'ing it to the webserver at seanet brought these complications. A great learning experience ! For all perl coders, your code may be right, but they may not have the drivers ;-).
On a side note, I installed this great windows connector app from mysql.com which allows you to test mysql ODBC connections putting in hostname, port no, database name, user name, and password. You hit the test button to see if the database connects or not ! Then you know whether they have the mysql drivers you need ;-)