Microsoft VBScript runtime (0x800A01A8) Object Required "

2 New Member

Sir,
I am trying with an asp page to handle with one Access Database. When I try to read from the Access file it comes correctly. But when I try to Add Records or Update the records it shows an error.
Microsoft VBScript runtime (0x800A01A8)
Object required: ''
NewAdmdone.asp, line 20
Kindly check my program and guide me.

Expand|Select|Wrap|Line Numbers

 
<html> <body bgcolor="33aa99">

<form>
 
<% n1=request(trim("n1"))

n2=request(trim("n2"))

n3=request(trim("n3"))

n4=request(trim("n4"))

n5=request(trim("n5"))

n6=request(trim("n6"))

n7=request(trim("n7"))

n8=request(trim("n8"))

n9=request(trim("n9"))
 
DIM sd

dim rs

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

sd.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source="&_

Server.MapPath ("/logon.mdb") & ";"

sd.Open

rs.open "insert into students (AdmNo,DOB,SName,Clas,Sec,FName,MName,Adrs,Phone)"&_

      "values("&n1&",'"&n2&"','"&n9&"',"&n3&",'"&n4&"','"&n5&"','"&n6&"','"&n7&"','"&n8&"')"%> 

  </center>

  <% rs.close

     sd.close

  %>

  <center> !Inserted Successfully!

   <a href="heading.asp"> <h3> Home</a></center>
 
</form></body> </html>

Thanking you

Nov 30 '11 #1

Subscribe Reply

4407

Rabbit

12,516

Recognized Expert Moderator MVP

You never create your recordset object.

Nov 30 '11 #2

Similar topics

7278

Microsoft VBScript runtime (0x800A01A8)

by: Matt | last post by:

The ASP page has a combo box with id list, and when user click the particular id, it will show the name in the text box. My attempt was when the user have event on combo box, it will call...

ASP / Active Server Pages

4792

urgent -- Please help. Microsoft VBScript runtime error '800a01a8'

by: Matrix | last post by:

I just got one virtual directory setup and try to run my web application from there. I am getting following error Microsoft VBScript runtime error '800a01a8' Object required: 'Session' I even...

ASP / Active Server Pages

8944

Error: VBScript runtime (0x800A01A8) Object required: '[object]'

by: Carolyn Speakman | last post by:

Hi, I'm trying to amend an intranet .asp page but keep getting this error. The error only occurs when I pull the WHOLE intranet off the server and try to run it locally. The error isn't there...

.NET Framework

4148

Microsoft VBScript runtime error '800a01a8'

by: Erica | last post by:

Here is the error I get. Line 13 is the 'do while f.AtEndOfStream = false' line. Your help is very much appreciated! Microsoft VBScript runtime error '800a01a8' Object required: 'f' ...

ASP / Active Server Pages

1013

Microsoft VBScript runtime error '800a01c9'

by: PaulieS | last post by:

Hi all. Am migrating a customer from IIS5 on W2K server to IIS6 on W2K3. Zipped all the websites and unzipped them to the identical locations on new server. Used IISMT to migrate metabase. ...

ASP / Active Server Pages

8822

Asp Error: Microsoft VBScript runtime (0x800A01A8) Object required: ''

by: Genken | last post by:

Hi can anybody help me i get this error when running this code. Error Type: Microsoft VBScript runtime (0x800A01A8) Object required: '' And then a line number indicating where the error is, i...

ASP / Active Server Pages

3866

Error Type:Microsoft VBScript runtime (0x800A01A8) line 262

by: mudasserrafiq | last post by:

I am using following asp file default.asp <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <META http-equiv=Content-Type content="text/html; charset=windows-1252"> <META content="0...

ASP / Active Server Pages

7988

Microsoft VBScript runtime (0x800A01A8) Object Required: "

by: jasone | last post by:

hi everyone! any advice given will be MUCH appreciated, i have spent about 10 hours on this bit of script... a rating system. I am having realt trouble overcoming this problem at runtime ...

ASP / Active Server Pages

24211

Getting "Microsoft JScript runtime error: Object expected"

by: EdEvans | last post by:

have the following code on a page: protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Page.ClientScript.RegisterStartupScript(this.GetType(), "DoPreview",...

Javascript

2608

VbScript error "VB runtime error : Object required”

by: ShyamKrishnegowda | last post by:

We are writing test scripts to our product. In one of the script we are facing an issue. This test script will create a COM component and executes the following function. O1 and O2 are out...

ASP / Active Server Pages

7165

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

5462

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4908

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4588

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3093

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3081

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1417

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

656

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

290

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General