ASP Access databsae error "Operation was canceled."
Posted on 2003-11-18
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
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&"');"