Re: tnsnames.ora file REQUIRING ip instead of name

Please post the asp code you use for the connection ( you may want to post it to an asp forum as well), it seems that it must be in that code, since Oracle 'knows' about dbserver...

deja-user_at_bitrealm.com (Brent Olson) wrote:

>Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<3kn2mu4shuihhpt23ks402ej8a2j47bsbe_at_4ax.com>...
>>
>> What is the result of
>> ping dbserver
>>
>> Your problem looks like a DNS issue to me.
>> Evidently installing Mickeysoft sorrow pack 3 screwed up your TCP/IP
>> stack.
>>
>> Hth
>>
>>
>> Sybrand Bakker, Senior Oracle DBA
>>
>> To reply remove -verwijderdit from my e-mail address
>
>c:\ ping dbserver
>Pinging dbserver.testco.com [172.16.2.100] with 32 bytes of data:
>
>Reply from 172.16.2.100: bytes=32 time<10ms TTL=255
>Reply from 172.16.2.100: bytes=32 time<10ms TTL=255
>Reply from 172.16.2.100: bytes=32 time<10ms TTL=255
>Reply from 172.16.2.100: bytes=32 time<10ms TTL=255
>
>Ping statistics for 172.16.2.100:
> Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
>Approximate round trip times in milli-seconds:
> Minimum = 0ms, Maximum = 0ms, Average = 0ms
>
>
>c:\ tnsping dbserver
>TNS Ping Utility for 32-bit Windows: Version 8.1.6.0.0 - Production on
>20-AUG-20
>02 08:00:19
>
>(c) Copyright 1997 Oracle Corporation. All rights reserved.
>
>Attempting to contact
>(ADDRESS=(PROTOCOL=TCP)(HOST=dbserver)(PORT=1521))
>OK (60 msec)
>
>Guaranteed that DNS (both forward and reverse) are setup correctly.
>The second I change tnsnames.ora, my .asp can't connect to the db any
>longer. When I change it back to the ip, it immediately starts
>working again. No need to restart IIS or anything. I even rebooted
>with tnsnames.ora saved using the name of the server. No dice.

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

   http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Tue Aug 20 2002 - 10:20:00 CDT