RE: Need Help with DBI for oracle

2011-06-03 Thread Harris, Marcus E (Marcus)
o:ganesh.b.ben...@gmail.com] > Sent: Thursday, June 02, 2011 9:48 AM > To: dbi-users@perl.org > Subject: Need Help with DBI for oracle > > Hi, > > I am using the following code for fetching some data. > but not able to connect > > *CODE:* > #!C:/Perl/bin/perl.exe &g

RE: Need Help with DBI for oracle

2011-06-03 Thread John Scoles
Simple connection problem. Try to connect SQLPlus if you can do that then you can use DBD::Oracel Try the same connection string in DBD:Oracle Hope this helps cheers John > CC: dbi-users@perl.org > From: jona...@gmail.com > Subject: Re: Need Help with DBI for oracle > Date

Re: Need Help with DBI for oracle

2011-06-03 Thread Jonas B. Nielsen
As you can read from the error message is not interpolated, exchange the single quotes for double quotes. Sorry for the abrupt response, but I am in transit jonasbn Sent from my iPhone On 02/06/2011, at 15.47, Ganesh Bendre wrote: > Hi, > > I am using the following code for fetching some dat

Need Help with DBI for oracle

2011-06-02 Thread Ganesh Bendre
Hi, I am using the following code for fetching some data. but not able to connect *CODE:* #!C:/Perl/bin/perl.exe use DBI; use DBD::Oracle; print "Content-type: text/html \n\n"; $platform = "ORACLE"; $database = "I8Q.GRP.COM"; $tablename = "COUNTY_ADD"; $user = "dba"; $pw = "dbapass"; $dsn = '