I am trying to connect to an Oracle database but I am getting this error:<BR>Microsoft OLE DB Provider for Oracle (0x80004005)<BR>ORA-12154: TNS:could not resolve service name <BR><BR>Here is my code:<BR>set conn = server.CreateObject ("ADODB.Connection")<BR>CS = "PROVIDER=MSDAORA.1;DATA SOURCE=source;USER ID=uid;PASSWORD=pw"<BR> conn.Open CS<BR> <BR> set objCmd = Server.CreateObject ("ADODB.Command")<BR> <BR> strSQL = "Select jobnum, name, issue from tbljob where jobnum = 12345"<BR> <BR> objCmd.CommandText = strSQL<BR> objCmd.CommandType = 1<BR> <BR> set objRS = Server.CreateObject ("ADODB.Recordset")<BR> <BR> objRS.Open objCmd