At 12:42 AM 9/5/2003 -0700, Dave Anderson wrote: >Go here: http://search.cpan.org/author/TIMB/DBI-1.38/ > >Download the DBI module. Unzip the archive, then run: > >perl Makefile.PL >make >make test >make install(if the other commands above don't complain) > >This should get you going. You might have to get a copy of gcc & GNU make. Once past >this step do the same for the DBD module, e.g. DBD::CSV or DBD::Oracle that you will >be using and perform the same steps. > >Oh, and you might want to reset your clock on the machine you use for email. >Apparently it was set for 9/12/2000 when you sent this message, and as a result your >messages are showing up at the bottom of my email list(probably everyone else's too). > >Dave A. > >Farhan wrote: > >>Can any one help me out from the error below.. i've been trying to use DBI module on >>win 2000 with Activeperl 5.6.4 and Perl 5.8 and Apache 2.0.. i dont know where i >>went wrong.. do i have to write any thing the system registry file.. plz help me >>out.. >> [Tue Sep 4 12:10:38 2003] [error] [client 127.0.0.1] Premature end of script >> headers: c:/program files/apache group/apache/cgi-bin/alldsn.cgi >>[Tue Sep 4 12:10:38 2003] [error] [client 127.0.0.1] Can't locate loadable object >>for module DBI in @INC (@INC contains: E:/Perl/lib E:/Perl/site/lib .) at >>E:/Perl/lib/DBI.pm line 255 >>[Tue Sep 4 12:10:38 2003] [error] [client 127.0.0.1] BEGIN failed--compilation >>aborted at E:/Perl/lib/DBI.pm line 255. >>[Tue Sep 4 12:10:38 2003] [error] [client 127.0.0.1] Compilation failed in require >>at c:\PROGRA~1\APACHE~1\apache\cgi-bin\alldsn.cgi line 4. >>[Tue Sep 4 12:10:38 2003] [error] [client 127.0.0.1] BEGIN failed--compilation >>aborted at c:\PROGRA~1\APACHE~1\apache\cgi-bin\alldsn.cgi line 4. >> >>i was unable to reach to the point where i can start using any database.. the >>problem is, i starts receiving error messages on use DBI; call... like on this >>command.... >> #!E:\perl\bin\perl.exe -w >> print "Content-type: text/html\n\n"; >>-->> use DBI; >>when i comment this line, my program starts working fine.. >>i have tried a lot to install DBI module through PPM.. but it gives me the following >>message >>C:\rep>ppm install dbi.ppd >>Error: no suitable installation target found for package DBI. >>i've also set the repository directories.. n added this DBI module in it.. but dont >>know wat is wrong in it.. >>your help will be really appreciated ... Farhan > > >
This won't be much help in Windows 2000 if he can't even get PPM going. Try this: 1. Run PPM from the command line 2. do: search DBI 3. Install the bundle. 4. Determine what database you are going to use. 5. search the PPM repository for the appropriate DBD module 6. If you are using Access you will need to use DBD::ODBC 7. If you need to - configure the odbc datasource in the control panel in w2k 8. Your error from the Apache means your script quit before it could output anything useful. 9. Make sure you turn on warnings in your script #!/usr/bin/perl -w or whatever, read the AS docs. 10. Enable error reporting in DBI ( RaiseError => 1) in the connection. 11. Make sure the CGI modules are installed (In AS it is easy, look to see if the documentation is in the HTML docs ) 12. make sure you put 'use CGI::Carp qw(fatalsToBrowser);' at the top of your script. Now you might have a chance, and you might get some usable error messages. John
