#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Posts
    22
    Rep Power
    0
    I'm trying to get Perl to connect to a MySQL database using DBI and
    DBD-Mysql on my Win '98 development platform, but cannot get the DBI module
    to work. The following line results in an internal server error:

    use DBI;

    I've got ActiveState Perl installed on my PC, and it works fine with all the
    standard modules. I've used ppm.pl to download and install by:
    install DBI
    to install the DBI module, and:
    install DBD-Mysql
    to install the Mysql driver.

    On installing them, it said everything was fine (at least, no errors),
    however the line "use DBI;" still returns a "500 Internal Server Error".

    I've tried uploading the file to the webserver which I'll be using, and
    there's no error there, and hence no other error with the file (tried
    #'shing out the line, and then there's no error either on home machine).

    Any ideas? Thanks in advance,

    ------------------
    -----------
    Jake Gordon
    Remove "SPAM" below,
    jakegSPAM@lineone.net
    www.jakeyg.com
  2. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Posts
    22
    Rep Power
    0
    OK, here's the server's error log - although I can't figure out what I need to change from this. I seem to have two instances of Perl installed - one in C:/perl and one in C:/usr/lib... could this be the problem?

    [error] [client 127.0.0.29] at C:/usr/site/lib/DBI.pm line 182
    [error] [client 127.0.0.29] BEGIN failed--compilation aborted at
    C:/usr/site/lib/DBI.pm line 182.
    [error] [client 127.0.0.29] BEGIN failed--compilation aborted at
    /usr/etc/htdocs/ninten/cgi-bin/index.cgi line 3.
    [error] [client 127.0.0.29] Premature end of script headers:
    /usr/etc/htdocs/ninten/cgi-bin/index.cgi
    [error] [client 127.0.0.29] Can't load 'C:/usr/site/lib/auto/DBI/DBI.dll'
    for module DBI: load_file:One of the library files needed to run this
    application cannot be foun at C:/usr/lib/DynaLoader.pm line 169.



    ------------------
    -----------
    Jake Gordon
    Remove "SPAM" below,
    jakegSPAM@lineone.net
    www.jakeyg.com

IMN logo majestic logo threadwatch logo seochat tools logo