Topic: Apache 2.2.4 and DBD::Sybase

[beach79]

I'm a newbie. If I'm posting this in the wrong place let me know...

I'm having trouble getting a cgi script that connects to the database using DBI and DBD::Sybase. I am on WindowsXP Professional SP2. I installed the latest ActivePerl(5.8., using the version of DBI that came with it. I installed DBD::Sybase using ppm. I have already connected to the database using DBI and DBD::Sybase with no problems. I also ran a cgi script (no connection to DB) with no problems. I ran the cgi script that connects to the DB in a command prompt and confirmed that it had no syntax errors and ran with no problems.

When I try to access my script through the browser an internal server error. When I checked the error logs I saw this..

[error] [client 127.0.0.1] Premature end of script headers: dbtst.cgi
[error] [client 127.0.0.1] Can't load 'C:/Perl/site/lib/auto/DBD/Sybase/Sybase.dll' for module DBD::Sybase: load_file:The specified module could not be found at C:/Perl/lib/DynaLoader.pm line 230.\r
[error] [client 127.0.0.1] at C:/Program Files/Apache Software Foundation/Apache2.2/cgi-bin/dbtst.cgi line 6\r
[error] [client 127.0.0.1] Compilation failed in require at C:/Program Files/Apache Software Foundation/Apache2.2/cgi-bin/dbtst.cgi line 6.\r
[error] [client 127.0.0.1] BEGIN failed--compilation aborted at C:/Program Files/Apache Software Foundation/Apache2.2/cgi-bin/dbtst.cgi line 6.\r

Line 6 of my script is use DBD::Sybase;
I went to line 230 of DynaLoader.pm and saw this...

# Many dynamic extension loading problems will appear to come from
# this section of code: XYZ failed at line 123 of DynaLoader.pm.
# Often these errors are actually occurring in the initialisation
# C code of the extension XS file. Perl reports the error as being
# in this perl code simply because this was the last perl code
# it executed.

my $libref = dl_load_file($file, $module->dl_load_flags) or
croak("Can't load '$file' for module $module: ".dl_error());

I dont know what they mean by the extension XS file.

I have changed nothing in the config file since the install. I haven't found anyone who had this problem before on any of the forums or any known bugs/issues with apache and DBD::Sybase. If there are should I be using sybperl instead?

Any insight greatly appreciated...