This belongs on dbi-users, so I am sending this response there.
You can make the change in your tnsnames.ora file or have the DBA make the
change in Oracle*Names if you are using that.
The very temporary workaround of "dbi:Oracle:host=123.123.123.123;sid=live"
should have worked as well. Try 'DBI->trace(2);' before the connect and see
what's in trace.log.
In any case, using the raw IP address should be considered only a stop gap;
whoever is managing the DNS needs to fix it. You shouldn't be the only one
being affected, it's time for the peasants to get their torches and
pitchforks and storm the castle.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
----- Original Message -----
From: "Jempty, George" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 16, 2002 10:47
Subject: IP instead of hostname in Oracle connection string
> I'm using a Windows2k/IIS/CGI program to report against Oracle data on a
> Unix machine, the Oracle version on both client and server is 8.1.7. The
> following connection string was working until the Windows2k box developed
a
> problem resolving DNS names:
>
> DBI->connect("dbi:Oracle:rwmccm_live.clinicom.com", "rwmc_ro", "rwmc_ro");
>
> Is there a way to re-write this using a combination of IP address and SID?
> The examples from the documentation seem to indicate a combination of
> hostname and SID might work as follows:
>
> DBI->connect("dbi:Oracle:host=rwmccm;sid=live", "rwmc_ro", "rwmc_ro")
>
> However, the Win2k server cannot reliably resolve DNS names, but can
always
> handle IP addresses. I tried the above with host=255.255.255.255 (not the
> actual IP address), which however resulted in two consecutive fatal NI
> connect errors in my sqlnet.log, #12505 and #12560.
>
> I can happily provide more information if it would help, or can this just
> not be done with an IP address? (If not I will have more leverage with
the
> network admins to get the DNS working)
>
> Thanks in advance
>
> George M. Jempty
> Database Administrator
> Regional West Medical Center
> Scottsbluff, Nebraska
> 308.630.2408
>
>
