|
|
Choosing A Webhost: |
jdbc connectivity issue in perl: msg#00200db.tds.freetds
i read through loads of archives before asking this. but still can't figure out where i am going wrong i have a small perl prog trying to connect to an oracle 9i db through DBD::JDBC. here's the code snippet: my $url="jdbc:oracle:thin:\@somehost.com:1790:TEST"; my $hostname="somehost.com"; my $port=1790; my $dsn="dbi:JDBC:hostname=$hostname;port=$port;url=$url;jdbc_character_set=ASCII"; my $user=some_user; my $password=some_pwd; print "DEBUG: connecting to JDBC using this conn string -- $dsn\n"; my $dbh=DBI->connect($dsn, $user, $password) or die $DBI::errstr; and here's the error i get DEBUG: these are the drivers: ExampleP JDBC Proxy Sponge DBI 1.38-nothread dispatch trace level set to 2 DEBUG: connecting to JDBC using this conn string -- dbi:JDBC:hostname=somehost.com;port=1790;url=jdbc:oracle:thin:@somehost.com:1790:TEST;jdbc_character_set=ASCII -> DBI->connect(dbi:JDBC:hostname=somehost.com;port=1790;url=jdbc:oracle:thin:@somehost.com:1790:TEST;jdbc_character_set=ASCII, some_user, ****) -> DBI->install_driver(JDBC) for linux perl=5.006001 pid=11683 ruid=1000 euid=1000 install_driver: DBD::JDBC version 0.64 loaded from /usr/local/share/perl/5.6.1/DBD/JDBC.pm <- install_driver= DBI::dr=HASH(0x81d35bc) -> connect for DBD::JDBC::dr (DBI::dr=HASH(0x81d35bc)~0x838c664 'hostname=somehost.com;port=1790;url=jdbc:oracle:thin:@somehost.com:1790:TEST;jdbc_character_set=ASCII' 'some_user' **** HASH(0x822baa4)) 1 -> trace in DBD::_::common for DBD::JDBC::dr (DBI::dr=HASH(0x838c664)~INNER) 1 <- trace= 2 at JDBC.pm line 88 !! ERROR: 101 'I/O Error ' <- connect= undef at DBI.pm line 585 -> errstr in DBD::_::common for DBD::JDBC::dr (DBI::dr=HASH(0x81d35bc)~0x838c664) error: 101 'I/O Error ' <- errstr= 'I/O Error ' at DBI.pm line 588 DBI connect('hostname=somehost.com;port=1790;url=jdbc:oracle:thin:@somehost.com:1790:TEST;jdbc_character_set=ASCII','guo_user',...) failed: I/O Error DBI connect(hostname=somehost.com;port=1790;url=jdbc:oracle:thin:@somehost.com:1790:TEST;jdbc_character_set=ASCII','guo_user',...) failed: I/O Error at ./db.pl line 25 -> $DBI::errstr (&) FETCH from lasth=HASH >> DBD::JDBC::dr::errstr <- $DBI::errstr= 'I/O Error ' -> $DBI::errstr (&) FETCH from lasth=HASH >> DBD::JDBC::dr::errstr <- $DBI::errstr= 'I/O Error ' I/O Error at ./db.pl line 25. -- DBI::END -> disconnect_all for DBD::JDBC::dr (DBI::dr=HASH(0x81d35bc)~0x838c664) 1 -> FETCH for DBD::JDBC::dr (DBI::dr=HASH(0x838c664)~INNER 'jdbc_connections') 1 <- FETCH= ( undef ) [1 items] at JDBC.pm line 316 <- disconnect_all= undef at DBI.pm line 653 ! -> DESTROY for DBD::JDBC::dr (DBI::dr=HASH(0x838c664)~INNER) ! <- DESTROY= (not implemented) during global destruction can someone tell me whats happening? -- k.p.
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | RE: datatype conversion, Lowden, James K |
|---|---|
| Next by Date: | Re: jdbc connectivity issue in perl, praveen |
| Previous by Thread: | Re: Compiling and using FreeTDS on Mac OS X, Duncan Wilcox |
| Next by Thread: | Re: jdbc connectivity issue in perl, praveen |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |