Try first to connect without DBI : sqlplus scott/[EMAIL PROTECTED] If success then Try to get more info of failure using trace() function of DBI. use DBI; DBI->trace(2); DBI->connect(...);
HTH, José. -----Original Message----- From: mohini sathe [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 3:25 PM To: [EMAIL PROTECTED] Subject: DBI->Connect probblem. Following is the query: After installing the following 1. Oracle9i installed (Both Client and server) 2. Installed Active perl 5.6 3. Installed DBI 1.37 4. Installed DBD-Oracle 1.12 With this installations when i tried to connect to Oracle database using DBI->Connect, this function fails. As i am a beginner to Perl and also to the Oracle9i m not able to debug and trace the actual cause. I have created the local database, ubrprod, entry in the tnsnames.ora is as follows: UBRPROD.CYBAGE.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = mohini)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = ubrprod) ) ) following is the code used to connect to database use DBI; # Load the DBI module $dbh = DBI->connect("dbi:Oracle:host=localhost;sid=ubrprod;port=1521","scott","tiger") || die "can not connect::",$DBI::errstr; exit; Running this perl results in connection error saying DBI connect('host=localhost;sid=ubrprod;port=1521','scott',...) failed: at G:\perltests\test_ora.pl line 8 can not connect:: at G:\perltests\test_ora.pl line 8. I need help to solve this problem. Thanks, Mohini. --------------------------------- Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! **** DISCLAIMER **** "This e-mail and any attachment thereto may contain information which is confidential and/or protected by intellectual property rights and are intended for the sole use of the recipient(s) named above. Any use of the information contained herein (including, but not limited to, total or partial reproduction, communication or distribution in any form) by other persons than the designated recipient(s) is prohibited. If you have received this e-mail in error, please notify the sender either by telephone or by e-mail and delete the material from any computer". Thank you for your cooperation. For further information about Proximus mobile phone services please see our website at http://www.proximus.be or refer to any Proximus agent. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
