Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Provider error '80040154'

Status
Not open for further replies.

H2

Programmer
May 17, 2001
24
0
0
HK
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(&quot;ADODB.Connection&quot;)
Set objRec = Server.CreateObject (&quot;ADODB.Recordset&quot;)
objCon.Open &quot;DSN=TestingDB;UID=test;PWD=test&quot;
objRec.Open &quot;cat&quot;, objCon, 1,3

objRec.AddNew
objRec(&quot;cat_no&quot;) = &quot;B1&quot;
objRec(&quot;CategoryName&quot;) = &quot;Testing B1&quot;

objRec.Update <-- line 15
objRec.Close

%>


Thanks
H2
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top