
amy1000
New User
Jan 11, 2009, 7:13 PM
Post #1 of 4
(8648 views)
|
DBI::Proxy for remote Oracle Database -error
|
Can't Post
|
|
Hi, 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:
#!C:\Perl\bin\perl.exe use CGI qw(:standard); use File::Temp qw/ tempfile /; use CGI::Carp qw(warningsToBrowser fatalsToBrowser); use strict; use Spreadsheet::WriteExcel; require "cgi-lib.pl"; print "Content-type: text/html\n\n"; print <<EndHTML; <h3><font color=#D02090>Model:</font></h3><h4> Rules for CDC Families</h4> EndHTML use strict; use DBI; 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" ); $dbh->disconnect; Thanks, Amy
(This post was edited by amy1000 on Jan 12, 2009, 6:51 PM)
|