Here's the situation...



IIS 4, NT 4, Active Server Pages, Oracle 8i, Oracle 8, Oracle ODBC 

Driver..... all patches up to date...



I have to connect to 5 (yes count them) 5 oracle servers... One is an 8i 

running on NT 4 and is right next to the web server and I connect with a 

service name and all is well and I can retrieve data.... 



However, I am having a he## of a time connecting to the 4 remote 

servers... I am using a SID instead of a service name and I keep getting 

the infamous ORA-12154 error... But the funny thing is that when I run the 

same code on a different remote server all is well... 



The TNSNAMES.ORA file is correctly configured ( IP's are correct, logins 

are correct, and SID value is correct )and I can connect to the four 

rebels with the web server via the Oracle ODBC Test, Net8 Assistant, and 

Net 8 Configuration Assistant... My gut instinct is telling me to shoot 

the box and torch what remains...