Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > Perl > oracle connect ; manual eror handling

Reply
Thread Tools

oracle connect ; manual eror handling

 
 
JONL
Guest
Posts: n/a
 
      03-18-2005
Have been connecting to oracle using the following with success
my $dbHandle = DBI->connect($sConnectString, $sUsername, $sPassword );
adding ,\%attr after password permits me to set the db handle options

But now we use a different connect syntax to support OS authentication:
my $sLoginString = "$sUsername/$sPassword";
my $dbHandle = DBI->connect($sConnectString, $sLoginString) ;

this will work but if I add \%attr after the LoginString, the connect
complains that I gave it an empty password. What I need to be able to
do is to use the second syntax but still be able to set dbh options.
ANy ideas?

 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
install_driver(Oracle) failed: Can't load 'C:/Perl/site/lib/auto/DBD/Oracle/Oracle.dll' for module DBD::Oracle: load_file:The specified procedure could not be found at C:/Perl/lib/DynaLoader.pm line 230. Feyruz Perl Misc 4 10-14-2005 06:47 PM
Attribute specifier is not a complete statement eror Justin Dutoit ASP .Net 1 10-05-2004 07:56 AM
RE: Oracle beginner problem: can't connect to Oracle using cx_Oracle Pieter Claerhout Python 0 01-28-2004 01:13 PM
Oracle beginner problem: can't connect to Oracle using cx_Oracle Benson, John Python 1 01-28-2004 12:55 PM
Help with this eror.. (Dataset as excel..) yyt ASP .Net 0 10-24-2003 02:48 PM



Advertisments
 



1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57