I have the same problem, if you've solved it please let me know.

> Hello all.
> 
> Details are as follows:
> 
> Win2k /IIS 5 / Oracle8 (all on the same development box)
> 
> Set up service name and made a sucessful connection test using Net8 
> Assistant. Checked tnsnames.ora file and I can see the proper entry for 
> the service connection (ORCLDEV). However, when I run the ASP script I 
get 
> the following error:
> 
> Error Type:
> Microsoft OLE DB Provider for Oracle (0x80004005)
> ORA-12154: TNS:could not resolve service name 
> /dev/includes/ADOFunctions_inc.asp, line 10
> 
> 
> Source code is as follows:
> 
> Function OpenDB()
> 
> 	Dim objConnection
> 
> 	Set objConnection = Server.CreateObject("ADODB.Connection")
> 	With objConnection
> 	    .ConnectionString = "Provider=MSDAORA;Data Source=ORCLDEV; 
> User ID=super; Password=secret;"
> 	    .Open
> 	End With    
> 	Set OpenDB = objConnection
> End Function	
> 
> 
> Any ideas are greatly appreciated.