Home: Perl Programming Help: DBI:
different ways of getting database handle



rajjj
Novice

Aug 10, 2006, 5:34 AM


Views: 4243
different ways of getting database handle

hi all,

im trying to connect remote database with different data given.

as im new to perl , im not getting the different possibilities.

can any body help me to get a db handle using different information like

sid, tns name, as sysdba, remotehost option ..

can u give me all possible syntax of getting a db handle..

i.e. $dbh = DBI->connect(different options)



any advice gr8ly appreciated..

thanx in advance..


davorg
Thaumaturge / Moderator

Aug 11, 2006, 6:35 AM


Views: 4240
Re: [rajjj] different ways of getting database handle

It depends on the DBD that you're using. It looks to me like you're using DBD::Oracle, so try reading the documentation for that module.

--
Dave Cross, Perl Hacker, Trainer and Writer
http://www.dave.org.uk/
Get more help at Perl Monks


rajjj
Novice

Aug 11, 2006, 8:40 AM


Views: 4238
Re: [davorg] different ways of getting database handle

hi davorg,

u r perfectly correct im using "oracle" DBD.

im going through the documentation .

thanx