I have installed active perl several times with no troubles..
But now i'm trying to install active perl and i'm having troubles with
Database SQLServer whith an ADO conection
i have the next script asp perl
use integer;
use DBI;
use Fcntl ':flock';
use IO::File;
my $dbh=DBI->connect('dbi:ADO:esmeralda1', 'sa', '', { RaiseError => 1});
use Data::Dumper;
$res= $dbh->selectall_arrayref("SELECT * FROM paises");
print Dumper($res);
if i execute from a command line i.e
c:> perl filenme
it works ok..
but if i try to execute this file translating to ASP file i.e
<%@ LANGUAGE = PerlScript%>
<%
use integer;
use DBI;
use Fcntl ':flock';
use IO::File;
my $dbh=DBI->connect('dbi:ADO:esmeralda1', 'sa', '', { RaiseError => 1});
#my $dbh=DBI->connect('dbd:dbi:ODBC:esmeralda1', 'sa', '', {
AutoCommit=>1,RaiseError => 1});
use Data::Dumper;
$res= $dbh->selectall_arrayref("SELECT * FROM paises");
$Response->Write(Dumper($res));
%>
<html>
</html>
it doesn't work and give me the follow error message
PerlScript Error error '80004005'
(in cleanup) Unable to load Win32::OLE::Const ``Microsoft ActiveX Data
Objects 2\.0 Library'' 0 at
C:/Perl/site/lib/DBD/ADO.pm line 74.
/prueba_conect.asp, line 3
could you help me???..
Scuse me for my einglish my native languge is Spanish..
i'll be waiting for a favorable response..
greatings
Martin Dominguez
