Hi People,


I am using IIS 5.0.The code stated below was taken altered by me from
Beginning ASP3.0 by WROX PUBLICATIONS.

NOTE:Both of the codes mentioned below work when i use PWS on WIN98 but not 
on IIS 5.0 in WINDOWS 2000 Professional.


Totally confused.I have included <!--METADATA TYPE="typelib"
             FILE="C:\Program Files\Common Files\System\ado\msado15.dll"-->


2 SETS OF CODE I HAVE TRIED.



1st stet of codesql ="Select * from MailingList"

rs.Open sql,objConn,adOpenStatic, adLockOptimistic,adCmdText

rs.AddNew
rs("Email")=email
rs.Update

Error returned is Server cannot perform such an operation.




2nd set of code


Dim  sql,objComm,intNoRec

set objComm=Server.CreateObject("ADODB.Command")

objComm.ActiveConnection =strConnect
objComm.CommandText ="INSERT INTO MailingList(Email)VALUES('"&email&"')"
objComm.CommandType =adCmdText
objComm.Execute intNoRec
Response.Write "No of recs inserted"


Error returned is query must be updateable query.