at the moment I'm going crazy with the same problem just
analyzed here: http://www.mail-archive.com/dbi-users@perl.org/msg25602.html
here again the problem:
I'm trying to test the connection betwwen my Sun SPARC 64bit - Solaris 10
and a remote Oracle DB.
--
#!/usr/bin/perl
use DBI;
$dbh
I wrote a script on an NT workstation using AS Perl 5.6.1, DBI 1.14, DBD-Oracle 1.06
and it works fine. It's supposed to run on an NT server and it fails there where the
version of perl is 5.005_02, PPM query shows that DBI and DBD are present but does not
give version information. I looked i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tue, Jan 08, 2002 at 09:57:48AM +0100, [EMAIL PROTECTED] wrote:
> Name "main::ORACLE_HOME" used only once: possible typo at test_dbi.pl
> line 4.
> main::(test_dbi.pl:4): $ORACLE_HOME='/opt/oracle/product/8.1.7';
Don't you mean $ENV{ORACLE_HOME}?
[EMAIL PROTECTED] [[EMAIL PROTECTED]] wrote:
>
> The listener is running, sqlplus is working...
> Some days ago I moved our sqlnet.ora to sqlnet.ora.old, stopped the
> listener and restarted the listener. No success. the same error.
>
> backgrund:
> december 2001 - dbi worked and NO sqlnet.ora w
The listener is running, sqlplus is working...
Some days ago I moved our sqlnet.ora to sqlnet.ora.old, stopped the
listener and restarted the listener. No success. the same error.
backgrund:
december 2001 - dbi worked and NO sqlnet.ora was located in $ORACLE_HOME/network/admin
02.01.- a
See below.
[EMAIL PROTECTED] [[EMAIL PROTECTED]] wrote:
> I want connect to a oracle database with a connect string in the form:
>
> dbi:Oracle:host=my_host;sid=my_sid;port=1521
>
> This failes with a the real hostname, but it works with IP-address of
> the
> host.
> Curious enough, a nslookup
I want connect to a oracle database with a connect string in the form:
dbi:Oracle:host=my_host;sid=my_sid;port=1521
This failes with a the real hostname, but it works with IP-address of
the
host.
Curious enough, a nslookup for this machine works too!
There is a entry in /etc/hosts for this machi