Re: Weird TNS error with DBI::Oracle 1.21 & oracle 11G

2008-07-29 Thread Jeffrey Seger
Standard troubleshooting applies: 1. Are you running the script as the same user? and with the same environment? (If you are running it in a webserver probably not). 2. Is this running under apache? If so, are the same environment variables being set in httpd.conf? Or are the old 8.1.6 variables

Re: Questions related to DBI and DBD::Oracle

2008-07-29 Thread scoles
You will have to install the DBD::Oracle perl module befoer you can use it. http://search.cpan.org/~pythian/DBD-Oracle-1.21/Oracle.pm so far you only have DBI or th Data Base Interface you need a Data Base Driver to make it actually connect ot a DB. This is why it is asking for DBD::Oracle > Hel

Re: Perl+DBI question [NC]

2008-07-29 Thread Srinivas KATTI
Hi, Now my admin guy has asked me to include different path and i did then i am getting following error [EMAIL PROTECTED]:[/home/glrecdev/icrs]> perl dbp.pl ld.so.1: perl: fatal: relocation error: file /tools/prod/apps/lib/site_perl/5.8.6/sun4-solaris//auto/DBI/DBI.so: symbol Perl_get_sv: refer

Questions related to DBI and DBD::Oracle

2008-07-29 Thread Shikha . Pandit
Hello, I am trying to connect to the oracle database through a perl script. I have installed DBI module on my server. I need to run my script on an App server and the database is on the other server. When I am running the test script which is use DBI; $dbh = DBI->connect( 'dbi:Oracle:dwhs01',

Re: Weird TNS error with DBI::Oracle 1.21 & oracle 11G

2008-07-29 Thread Bruce Johnson
On Jul 29, 2008, at 11:51 AM, Bruce Johnson wrote: Perl 5.8, DBI 1.607, DBI::Oracle 1.21, Oracle 11g (11.1.0) Any script I try to run results in the error: Database connection not made: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServe

Weird TNS error with DBI::Oracle 1.21 & oracle 11G

2008-07-29 Thread Bruce Johnson
Perl 5.8, DBI 1.607, DBI::Oracle 1.21, Oracle 11g (11.1.0) Any script I try to run results in the error: Database connection not made: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach) at ./testdbi.pl line 9. This script works c

Re: Perl+DBI question [C1]

2008-07-29 Thread David Dooling
On Tue, Jul 29, 2008 at 06:10:30PM +0530, Amit Saxena wrote: > On Tue, Jul 29, 2008 at 6:05 PM, Tim Bunce <[EMAIL PROTECTED]> wrote: > > On Mon, Jul 28, 2008 at 08:36:23PM +0530, Srinivas KATTI wrote: > > > I am working on perl assignment which is first perl code in our > > > environment, i have co

Re: Perl+DBI question [NC]

2008-07-29 Thread Srinivas KATTI
Thanks a lot Tim, i am checking with Unix admin to do that and let's see once done Thanks again Regards Srinivas K [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/29/2008 06:05 PM To Srinivas KATTI/ia/[EMAIL PROTECTED] cc dbi-users@perl.org, [EMAIL PROTECTED] Subject Re: Perl+DBI question [C

Re: Perl+DBI question [NC]

2008-07-29 Thread Srinivas KATTI
Hi Jonjathan, First of all Thank you very much for the quick response, i tried with modified path you mentioned and also blib, it did not work. I think the DBI is not installed properly, our admin might have did just unzipped the files, may not have done "make", let me clarify with them, becaus

Re: Perl+DBI question [C1]

2008-07-29 Thread Amit Saxena
On Tue, Jul 29, 2008 at 6:05 PM, Tim Bunce <[EMAIL PROTECTED]> wrote: > On Mon, Jul 28, 2008 at 08:36:23PM +0530, Srinivas KATTI wrote: > > Hi > > > > I am working on perl assignment which is first perl code in our > > environment, i have come across following problem, pls if you could > > provide

Re: Perl+DBI question [C1]

2008-07-29 Thread Tim Bunce
On Mon, Jul 28, 2008 at 08:36:23PM +0530, Srinivas KATTI wrote: > Hi > > I am working on perl assignment which is first perl code in our > environment, i have come across following problem, pls if you could > provide your expert consultansy it will be great help to me > > I am trying to use DB

Re: Perl+DBI question [C1]

2008-07-29 Thread Peter J. Holzer
On 2008-07-28 20:36:23 +0530, Srinivas KATTI wrote: > I am working on perl assignment which is first perl code in our > environment, i have come across following problem, pls if you could > provide your expert consultansy it will be great help to me > > I am trying to use DBI in my program (simp