The dbi-dev list is not for driver support issues. Use dbi-users.
Tim.
On Wed, Jan 16, 2002 at 11:47:17AM -0700, Jempty, George wrote:
> 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
>
