Solved

ASP Access databsae error "Operation was canceled."

Posted on 2003-11-18
13
926 Views
Last Modified: 2007-12-19
I am making a simple ASP script so two people can enter in a couple of fields on info into a very simple access databsae from many locations. I have 8 fields that data is entered into, and passed into an asp script to write to the DB.

i get this error, which i have never seen before

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E4E)
Operation was canceled.
/write.asp, line 37

Line 37 of write.asp is,

rs.open asql, "DSN=data"

My "asql" is

asql="INSERT INTO [tblairport] (ode, ort, ddress, hone, ax, ebsite, one, erminals) VALUES ('"&ode&"','"&ort&"','"&ddress&"','"&hone&"','"&ax&"','"&ebsite&"','"&ime_zone&"','"&erminals&"');"

Thank you


0
Comment
Question by:CKudrna
13 Comments
 
LVL 3

Expert Comment

by:evrcool
Comment Utility
Do you have the ODBC settings correct in the control panel for "data"? Does the connection there test good? Are the drivers the correct drivers? Also, you could try doing a DSNLess connection.
0
 
LVL 29

Expert Comment

by:David H.H.Lee
Comment Utility
CKudrna,
Check your details error at this site :
http://www.aspfaq.com/show.asp?id=2332
0
 

Author Comment

by:CKudrna
Comment Utility
The database was used successfully in the past, and i changed the tables around for this new simple task i wanted to accomplish. The database name is the same, and the DSN connnection still exists.

I can't find what this error means, anyone really know? Is it a DSN problem or a ASP scripting problem?

The database file is in place correctly as per the DSN entry.
0
 
LVL 29

Expert Comment

by:David H.H.Lee
Comment Utility
CKudrna ,
View all the possibility error (0x80040E4E) may arrise based on the article that i shown to you in my first comments.
0
 
LVL 1

Expert Comment

by:devg
Comment Utility
hi!
Can you first establish the connection object with DSN and try like
rs.open asql, connectionName
0
 

Author Comment

by:CKudrna
Comment Utility
Yeah it is not in that list, sorry

there is no underscore, and yes, i will use DSN

this connection has worked fine in the past.

increasing points to 300

if anyone can let me know how to fix it without having to be at the server ill give you 500
0
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 29

Expert Comment

by:David H.H.Lee
Comment Utility
I suggest you use DSN-less connection method rather than DSN method.
0
 
LVL 29

Expert Comment

by:David H.H.Lee
Comment Utility
CKudrna ,
If you prefer use DSN, i would like you to make a simple a select statement to check wheter you can use the DSN method or not(maybe some setting problems?).

asql="select * from tblairport"
rs.open asql, "DSN=data;"

Regards
x_com
0
 
LVL 29

Expert Comment

by:David H.H.Lee
Comment Utility
i think this the mistake :
rs.open asql, "DSN=data;"

Change to
Set objConnection= Server.CreateObject("ADODB.Connection")

objConnection.open "DSN=data;"
rs.open asql, objConnection
0
 

Author Comment

by:CKudrna
Comment Utility
Changed to
Set objConnection= Server.CreateObject("ADODB.Connection")

objConnection.open "DSN=data;"
rs.open asql, objConnection


Still get the same error

I would like to use DSN because i just want this simple thing working, and i am thousands of miles away form the server, so i can't be setting up other connections remotely

any way i can point to this database file as in (http://domain.com/data.mdb) to edit it?

thanks

increasing the points again
0
 
LVL 29

Expert Comment

by:David H.H.Lee
Comment Utility
CKudrna ,
DSN-less connection is the easiest way to get it work around in asp. less configuration. If you prefer DSN connection, can you state out more details about it? Maybe your problems is different with others?
0
 
LVL 1

Accepted Solution

by:
abnish earned 350 total points
Comment Utility
Hi CKudrna,
the query you have defined in asql is a insert query, it will not return any recodset thats why you are getting the error. You can do this in following way:

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

strConnectionString = "Your connection string"

objConn.Open strConnectionString

objConn.Execute asql

Hope this will work without any error.

If you want to test your connection string then open a standard exe project in VB add a component of "Microsoft ADO 6.0" in your project and add the object in your form, right click on the object and open the property page, click on the "Use Connection String" radio button and click on "Build" command button, provide your DSN name and user id & password (if any) then click on test connection, if it succeed then click on "OK" button you will see the connection string in the text box, use this connection string in your ASP pages.

Happy Programmin!!
Abnish



0
 
LVL 29

Expert Comment

by:David H.H.Lee
Comment Utility
Ckudrna,
Please read this article too :
http://www.asp101.com/articles/jason/reversedns/default.asp
You may close/refund this thread if you found the solutions
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
I was asked about the differences between classic ASP and ASP.NET, so let me put them down here, for reference: Let's make the introductions... Classic ASP was launched by Microsoft in 1998 and dynamically generate web pages upon user interact…
This video discusses moving either the default database or any database to a new volume.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now