Jan 11, 2009, 7:13 PM
DBI::Proxy for remote Oracle Database -error
Im trying to connect to a remote Oracle database using DBI::ProxyServer. I have started the server on port 3333 on the machine.
However i encounter the following error (from the apache logs)
[Sun Jan 11 21:42:27 2009] [error] [client 127.0.0.1] [Sun Jan 11 21:42:27 2009] trydb4proxy.cgi: DBI connect('hostname=128.213.xx.xxx;port=3333;dsn=dbi:Oracle:XE','xxxx',...) failed: Cannot log in to DBI::ProxyServer: Error while reading socket: Bad file descriptor at C:/Perl/site/lib/RPC/PlServer/Comm.pm line 144.
Is there a specific confiuration that I have to set at the server side. What is going wrong?
I think i should also mention that I had trouble while installing the DBI::Proxy modules. Could that be the cause of error.
I have attached the Comm.pm file
My code is as follows:
use CGI qw(:standard);
use File::Temp qw/ tempfile /;
use CGI::Carp qw(warningsToBrowser fatalsToBrowser);
print "Content-type: text/html\n\n";
<h3><font color=#D02090>Model:</font></h3><h4> Rules for CDC Families</h4>
use Oracle::SQLLoader qw/$CHAR $INT $DECIMAL $DATE/;
my $dsn = "dbi:Oracle:XE";
my $proxy = "hostname=128.213.xx.xxx;port=3333";
my $dbh = DBI->connect( "dbi:Proxy:$proxy;dsn=$dsn", "uname", "passwd" );
(This post was edited by amy1000 on Jan 12, 2009, 6:51 PM)