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

  Main Index MAIN
Search Posts SEARCH
Who's Online WHO'S
Log in LOG

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

New User

Jan 11, 2009, 7:13 PM

Views: 5315
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] [Sun Jan 11 21:42:27 2009] trydb4proxy.cgi: DBI connect(';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/ 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 file

My code is as follows:


use CGI qw(:standard);
use File::Temp qw/ tempfile /;
use CGI::Carp qw(warningsToBrowser fatalsToBrowser);
use strict;
use Spreadsheet::WriteExcel;

require "";

print "Content-type: text/html\n\n";

print <<EndHTML;
<h3><font color=#D02090>Model:</font></h3><h4> Rules for CDC Families</h4>

use strict;
use DBI;

use Oracle::SQLLoader qw/$CHAR $INT $DECIMAL $DATE/;

my $dsn = "dbi:Oracle:XE";
my $proxy = ";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)
Attachments: (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