CGI/Perl Guide | Learning Center | Forums | Advertise | Login
Site Search: in

  Main Index MAIN
INDEX
Search Posts SEARCH
POSTS
Who's Online WHO'S
ONLINE
Log in LOG
IN

Home: Perl Programming Help: DBI: DBI::Proxy for remote Oracle Database -error: Edit Log



amy1000
New User

Jan 11, 2009, 7:13 PM


Views: 4394
DBI::Proxy for remote Oracle Database -error

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:

Code
 
#!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)
Attachments: Com_.pm (5.95 KB)


Edit Log:
Post edited by amy1000 (New User) on Jan 12, 2009, 6:51 PM


Search for (options) Powered by Gossamer Forum v.1.2.0

Web Applications & Managed Hosting Powered by Gossamer Threads
Visit our Mailing List Archives