Dear Sir, 

I hava problem in connect oracle with asp. Here is my source code:

Host String = oracle





     strCnn = "Provider=OraOLEDB.Oracle;User ID=group0002;Password=com4a;Host 

String=oracle;"

	Set oCon = Server.CreateObject("ADODB.Connection")

 oCon.Open strCnn

 set oRes = oCon.Execute ("SELECT * FROM dept")



    For I = 0 To oRes.Fields.Count - 1

       Response.Write "<td><b>" & oRes(I) & "</b></td>"

     Next



     oRes.Close

     oCon.Close

response.write "ok <br>"

	%>

    







And here is the error message:





ADODB.Connection error '800a0e7a' 

ADO could not find the specified provider. 

/project02/oooo.asp, line 11