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
