more useful options | |
PerlMonks |
Re^3: DBI connect without an entry in TNSNAMES.ORAby clscott (Friar) |
on Nov 10, 2006 at 20:29 UTC ( [id://583403]=note: print w/replies, xml ) | Need Help?? |
You absolutely can connect from a client with no tnsnames.ora file, I do it all of the time, with the same syntax that you are using. You have obvoiusly not been using valuable tools that are available to you: the documentation for DBD::Oracle and oracle client tools The documentation for DBD::Oracle has a huge amount of documentation regarding connections and you can view it on the CPAN http://search.cpan.org/dist/DBD-Oracle/ You have a bad SID/host combination in your script or in your environment. Read the DBD::Oracle documentation on connections and which piece of configuration data (DBI connection string; DBD environment variables; DBI environmant variables; Oracle client files and environment variables) interact. Especially the precedence. Here are some more options on how you could attempt to debug the issues:
Finally, when people are trying to help you and ask you questions, answer the questions.
-- Clayton
In Section
Seekers of Perl Wisdom
|
|