hi, there's an error in my code:
Provider error '80040154'
Class not registered
/testdb.asp, line 15
testdb.asp:
<%
dim objRec, objCon
set objCon = server.CreateObject("ADODB.Connection"
Set objRec = Server.CreateObject ("ADODB.Recordset"
objCon.Open "DSN=TestingDB;UID=test;PWD=test"
objRec.Open "cat", objCon, 1,3
objRec.AddNew
objRec("cat_no"
= "B1"
objRec("CategoryName"
= "Testing B1"
objRec.Update <-- line 15
objRec.Close
%>
Thanks
H2
Provider error '80040154'
Class not registered
/testdb.asp, line 15
testdb.asp:
<%
dim objRec, objCon
set objCon = server.CreateObject("ADODB.Connection"
Set objRec = Server.CreateObject ("ADODB.Recordset"
objCon.Open "DSN=TestingDB;UID=test;PWD=test"
objRec.Open "cat", objCon, 1,3
objRec.AddNew
objRec("cat_no"
objRec("CategoryName"
objRec.Update <-- line 15
objRec.Close
%>
Thanks
H2