Microsoft VBScript runtime error '800a01a8'

6 New Member

Hi folks,

I am a bit new to asp, and I am trying to get my form to write to an Access DB and send a confirmation email to the user when they submit the form.

I am getting this error:

[BMicrosoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN for process 0xe34 Thread 0xac0 DBC 0xd03c00c Jet'.

/formaction.asp, line 55
[/b]

Here is my code:

Expand|Select|Wrap|Line Numbers

 #51 <%

#52 Dim conn, rs 

#53 Set conn=Server.CreateObject("ADODB.Connection")

#54 Set rs=Server.CreateObject("ADODB.Recordset")

#55 conn.Open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=URL=fpdb/default4.mdb"

#57

#58 rs.Open "default4.mdb", conn, 2, 3

#59 rs.addnew

#60 rs("inputname")=Request.Form("Name")

#61 rs("inputname")=Request.Form("Email")

#62 rs("inputname")=Request.Form("Title")

#63 rs("inputname")=Request.Form("Dealership")

#64 rs("inputname")=Request.Form("Feb23_Reception")

#65 rs("inputname")=Request.Form("Feb24_Business_Meetings")

#66 rs("inputname")=Request.Form("Feb24_AB_VIP_Tour")

#67 rs("inputname")=Request.Form("Feb25_Business_Meetings")

I have a global.asa file, but I don't know enough .asp to make this work and I have been scouring the Internet for days.

Any wisdom, guidance and/or help would be greatly appreciated.

Thanks,

Jim

Sep 10 '08 #1

Subscribe Reply

4710

omerbutt

638

Contributor

hi Jim,
use this way and to connect to your access database and the connection string would be this one here

Expand|Select|Wrap|Line Numbers

 
Set rs=Server.CreateObject("ADODB.Recordset")

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

conn="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.mappath("fpdb/default4.mdb")

sql_string="select * from table;"

rs.CursorType = 2

rs.LockType = 3

rs.open sql_string,conn,3

rs.addnew

rs.fields("inputname")=Request.Form("Name")

rs.fields("inputname")=Request.Form("Email")

rs.fields("inputname")=Request.Form("Title")

rs.fields("inputname")=Request.Form("Dealership")

rs.fields("inputname")=Request.Form("Feb23_Reception")

rs.fields("inputname")=Request.Form("Feb24_Business_Meetings")

rs.fields("inputname")=Request.Form("Feb24_AB_VIP_Tour")

rs.fields("inputname")=Request.Form("Feb25_Business_Meetings")

rs.update

rs.close

tell me if there is any error using this method its been 5 years i have known asp and i have tried all the ways and all the connection strings and this method was the only one that never gave me any problems ......NEVER
Regards,
Omer Aslam

Sep 11 '08 #2

upperme

New Member

Hi Omer,

Thank you very much for your reply. I inserted your code, but I got a new error:

Microsoft JET Database Engine error '80040e14'

Syntax error in FROM clause.

/formaction.asp, line 58

Here is my complete code... I am trying to write to an Access db and generate a confirmation email to the registrant, in case I didn't mention it in my other post.

Expand|Select|Wrap|Line Numbers

 <%

Set rs=Server.CreateObject("ADODB.Recordset")

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

conn="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.mappath("fpdb/default4.mdb")

sql_string="select * from table;"

rs.CursorType = 2

rs.LockType = 3

rs.open sql_string,conn,3

rs.addnew

rs.fields("inputname")=Request.Form("Name")

rs.fields("inputname")=Request.Form("Email")

rs.fields("inputname")=Request.Form("Title")

rs.fields("inputname")=Request.Form("Dealership")

rs.fields("inputname")=Request.Form("Feb23_Reception")

rs.fields("inputname")=Request.Form("Feb24_Business_Meetings")

rs.fields("inputname")=Request.Form("Feb24_AB_VIP_Tour")

rs.fields("inputname")=Request.Form("Feb25_Business_Meetings")

rs.fields("inputname")=Request.Form("CAT_Update")

rs.fields("inputname")=Request.Form("NACD_Update")

rs.fields("inputname")=Request.Form("Power_Systems")

rs.fields("inputname")=Request.Form("CAT_Financial")

rs.fields("inputname")=Request.Form("Product_Support")

rs.fields("inputname")=Request.Form("CAT_Panel_Discussion")

rs.fields("inputname")=Request.Form("CAT_Path_to_2010_Goals")

rs.fields("inputname")=Request.Form("Rental_Used_Update")

rs.fields("inputname")=Request.Form("Dealer_Breakout_Session")

rs.fields("inputname")=Request.Form("Dealer_Best_Practices")

rs.fields("inputname")=Request.Form("Best_Practices_Ideas")

rs.fields("inputname")=Request.Form("Add_Topics")
 
rs.Update

rs.MoveLast

strId=rs("id")
 
rs.Close

conn.Close

Set rs=nothing

Set conn=nothing

Response.Write "ID#: " & strId

%>

Thanks again for your reply.

Jim

Sep 11 '08 #3

upperme

New Member

Let me update this line number to avoid any confusion...

Line 58 actually = rs.open sql_string,conn ,3

I just caught that...

Thanks again,

Jim

Sep 11 '08 #4

DrBunchman

979

Recognized Expert Contributor

Jim, there's a SQL syntax error in your SQL string. It looks pretty simple though so not sure what could be causing it - is "table" actually the name of your table?

Dr B

Sep 11 '08 #5

upperme

New Member

Dr B,

The name of the table is Results. I changed to Results from table, and now I get this error:

Expand|Select|Wrap|Line Numbers

 ADODB.Recordset error '800a0cc1' 
 
Item cannot be found in the collection corresponding to the requested name or ordinal. 
 
/formaction.asp, line 60

Code for line 60 = rs.fields("inpu tname")=Request .Form("Name")

Thanks very much,

Jim

Jim, there's a SQL syntax error in your SQL string. It looks pretty simple though so not sure what could be causing it - is "table" actually the name of your table?

Dr B

Sep 11 '08 #6

DrBunchman

979

Recognized Expert Contributor

Jim,

Then there is no column called "inputname" in your table Results. Make sure that all the fields that you are trying to update exist in your table and are spelt correctly.

Hope this helps,

Dr B

Sep 11 '08 #7

upperme

New Member

OK, thanks DrB... I think I am getting close... here is my current code:

Expand|Select|Wrap|Line Numbers

 <%

Set rs=Server.CreateObject("ADODB.Recordset")

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

conn="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="&server.mappath("fpdb/default4.mdb")

sql_string="select * from [Results]"

rs.CursorType = 2

rs.LockType = 3

rs.open sql_string,conn,3

rs.addnew

rs.fields("Name")=Request.Form("Name")

rs.fields("Email")=Request.Form("Email")

rs.fields("Title")=Request.Form("Title")

rs.fields("Dealership")=Request.Form("Dealership")

rs.fields("Feb23_Reception")=Request.Form("Feb23_Reception")

rs.fields("Feb24_Business_Meetings")=Request.Form("Feb24_Business_Meetings")

rs.fields("Feb24_AB_VIP_Tour")=Request.Form("Feb24_AB_VIP_Tour")

rs.fields("Feb25_Business_Meetings")=Request.Form("Feb25_Business_Meetings")

rs.fields("CAT_Update")=Request.Form("CAT_Update")

rs.fields("NACD_Update")=Request.Form("NACD_Update")

rs.fields("Power_Systems")=Request.Form("Power_Systems")

rs.fields("CAT_Financial")=Request.Form("CAT_Financial")

rs.fields("Product_Support")=Request.Form("Product_Support")

rs.fields("CAT_Panel_Discussion")=Request.Form("CAT_Panel_Discussion")

rs.fields("CAT_Path_to_2010_Goals")=Request.Form("CAT_Path_to_2010_Goals")

rs.fields("Rental_Used_Update")=Request.Form("Rental_Used_Update")

rs.fields("Dealer_Breakout_Session")=Request.Form("Dealer_Breakout_Session")

rs.fields("Dealer_Best_Practices")=Request.Form("Dealer_Best_Practices")

rs.fields("Best_Practices_Ideas")=Request.Form("Best_Practices_Ideas")

rs.fields("Add_Topics")=Request.Form("Add_Topics")
 
rs.Update

rs.MoveLast

strId=rs("id")
 
rs.Close

conn.Close

Set rs=nothing

Set conn=nothing

Response.Write "ID#: " & strId

%>

*Line 86 = Line 36 here

However, now I am getting this error:

Microsoft VBScript runtime error '800a01a8'

Object required: 'Provider=Micro soft.J'

/formaction.asp, line 86

Thanks for all your help!

Jim

Jim,

Then there is no column called "inputname" in your table Results. Make sure that all the fields that you are trying to update exist in your table and are spelt correctly.

Hope this helps,

Dr B

Sep 12 '08 #8

omerbutt

638

Contributor

just remove Conn.close from your code you dont need to close the connection ,you already closing the recordset so its okay

Sep 15 '08 #9

upperme

New Member

That did it! Thanks very much for all your help...:)

Jim

just remove Conn.close from your code you dont need to close the connection ,you already closing the recordset so its okay

Sep 17 '08 #10

Similar topics

10825

Microsoft VBScript runtime error '800a000b' vs HTTP 500 - Internal server error

by: | last post by:

I am accessing the same error-containing ASP page on an ISP server using w2k IE6 but with different effect. On the first computer I get several line of HTML outputed by ASP, shown correctly by the browser, followed by a descriptive error message: Microsoft VBScript runtime error '800a000b' Division by zero followed by the number of the error-making line

ASP / Active Server Pages

4815

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 try to create test.asp and put it in wwwroot folder only code I had was <% Response.write Session.SessionID %>

ASP / Active Server Pages

4259

Microsoft VBScript runtime error '800a01a8'

by: g_sharad | last post by:

I guess this is a very old problem, but this keeps bugging many ppl in many ways. I am facing the problem with the SQL query >>>> Insert Into DailySalesReport (hoautoid, dsdate, dsreport, dsclientid, dsprincipleid, dsremarks, dsadminlock ) Values (5,'2/16/2005','sacc',1,1,'cdssd','not') This query runs fine on query analyser, but when I try to put in asp page and then it gives the runtime error as >>

Microsoft Access / VBA

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. Got this error when I tried to run a very basic page... code: <%@ LANGUAGE=vbscript %> <%

ASP / Active Server Pages

15807

Microsoft VBScript runtime error '800a0046'

by: anidmarty | last post by:

Hey I'm a Sysadmin and my users are getting this error on my production box. It works fine on the dev box. There is a script that is run that generates this error. Production is clustered environment using Microsoft Application Center. This was working before and starting throwing this error about 15 days ago. any help would be much appreciated thanks

IIS / Internet Information Server

2068

Microsoft VBScript runtime error '800a13ba'

by: =?Utf-8?B?TWF0dCBDYWxob29u?= | last post by:

HI there, I am getting an error on my page which calls up a web service. Microsoft VBScript runtime error '800a13ba' Unknown runtime error: 'SearchQueryXML' /SearchResults.asp, line 142

.NET Framework

8848

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 cant see any errors with this code please assist. Thanks in advance. <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%>

ASP / Active Server Pages

2529

why do i am getting Microsoft VBScript runtime error '800a01a8'

by: nitindel | last post by:

Hi All, Please let me know that why i am getting the error like this:- Microsoft VBScript runtime error '800a01a8' Object required /Melange/MasconNet/singlesignon.asp, line 49

ASP / Active Server Pages

6611

WScript.Shell Microsoft VBScript runtime error '800a0046'

by: .nLL | last post by:

Erorr is --------------------- Microsoft VBScript runtime error '800a0046' Permission denied /a.asp, line 3 -----------------------

ASP / Active Server Pages

10137

Microsoft VBScript runtime error '800a01a8': Object required: 'objFolder'

by: gray d newbie | last post by:

Greetings All, I'm new to this forum as well as to ASP. Therefore I am ready to learn from the ASP experts in this forum. Thank you very much in advance. I was assign to develop a ASP based website, and one of the functions offer in this site is that the end user is able to print all files located in a specific folder, and the files were actually generated in the folder based on the end user selection. After printing, the files will be...

ASP / Active Server Pages

9669

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

10207

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

9995

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9029

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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

7537

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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5431

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 last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5559

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

4110

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 we have to send another system

C# / C Sharp

2916

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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General