Hi Everyone: Thanks a lot for all your help. At this moment, when I log in the proxy server, then run the code I can connect to the postgresql database successful. but when I connect from remote server, the following error message appear:
----------------------- DBI->connect(hostname=monosiga.bcm.umontreal.ca;port=6503;dsn=dbi:Pg:dbname=tempDB) failed: Cannot log in to DBI::ProxyServer: Unexpected EOF from server at /usr/local/lib/perl5/5.8.0/sun4-solaris/RPC/PlClient.pm line 83. at test line 6 Can't call method "disconnect" on an undefined value at test line 7. ------------------------ what is wrong? any help is appreciated. code ************* #!/usr/bin/env perl -w use DBI; $dsn="dbi:Pg:dbname=tempDB"; $proxy="hostname=monosiga.bcm.xxx.xx;port=6503"; $dbh=DBI->connect("dbi:Proxy:$proxy;dsn=$dsn", 'postgres', ' '); $dbh->disconnect; ********** Ning _________________________________________________________________ Join the world’s largest e-mail service with MSN Hotmail. http://www.hotmail.com