Solved

error 'ASP 0115' Unexpected error /index.asp A trappable error occurred in an external object. The script cannot continue running.

Posted on 2003-11-04
6
1,435 Views
Last Modified: 2010-05-18
HELP!!

error 'ASP 0115'
Unexpected error

/index.asp

A trappable error occurred in an external object. The script cannot continue running.

-----

My code is

-----

else if Page="EDAP" then

'Check the database to see if user exists and read in there password
'Initialise the strAccessDB variable with the name of the Access Database
strAccessDB = "Availability"

'Create a connection odject
Set adoCon = Server.CreateObject("ADODB.Connection")
                  
'Database connection info and driver
strCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath(strAccessDB)

'Set an active connection to the Connection object
adoCon.Open strCon

'Create a recordset object
Set rsDB = Server.CreateObject("ADODB.Recordset")
Set rsDBB = Server.CreateObject("ADODB.Recordset")

'Initalise the strSQL variable with an SQL statement to query the database
strSQL = "SELECT * FROM CoreTrainers WHERE ID=" & request.form("CT")

rsDB.Open strSQL, strCon

MonthS=request.form("MonthS")
YearS=request.form("YearS")

strSQL = "SELECT * FROM Availability WHERE (ID=" & request.form("CT") & ") AND ([Availability Date],7)=" & MonthS & "/" & YearS & " ORDER BY [Availability Date]"

rsDBB.Open strSQL, strCon

response.write "<br><center><font face=Arial>Editing availability for " & rsDB("Forenames") & " " & rsDB("Surname") & " (XX/" & MonthS & "/" & YearS & ")"

do until rsDBB.EOF
DayS=left(rsDBB("Availability Date"), 2)
response.write DayS
rsDBB.MoveNext
loop

response.write "<center><form method=POST action=index.asp?Page=EDAPB><input type=hidden name=ID value=" & rsDB("ID") & ">"
response.write "Availability dates: <input type=text size=40 name=Avail value=""" & Avail & """><br><br>"
response.write "If Joe Bloggs is available between the 3rd and the 8th, and then available for the 1st/12th/16th, the information you would enter would be:<br><br>1, 3-8, 12, 16"
response.write "<br><br><input type=Submit value=""Edit Availability"">"

rsDB.Close
rsDBB.Close

0
Comment
Question by:Sir_Brock
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 21

Accepted Solution

by:
ap_sajith earned 125 total points
ID: 9678121
0
 
LVL 6

Expert Comment

by:Programming_Gal
ID: 9685377
Agree with ap_sajith
0
 

Author Comment

by:Sir_Brock
ID: 9685920
Well, would it help if I told you I'm on Windows ME using PWS?

Even if it isn't supposed to be on Windows ME, it does work.
0
 
LVL 21

Expert Comment

by:ap_sajith
ID: 9686113
Have you given permissions on the mdb file for the IUSR Account?/
Cheers!!
0
 
LVL 7

Expert Comment

by:vnvk
ID: 11694258
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
    Accept: ap_sajith {http:#9678121}

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

vnvk
EE Cleanup Volunteer
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
wordpress display sub menu only when click 12 92
Filktering Alphabetically 8 46
ASP and Looping Thru a XML Document 4 45
ASP and Extracting XML 7 44
I recently decide that I needed a way to make my pages scream on the net.   While searching around how I can accomplish this I stumbled across a great article that stated "minimize the server requests." I got to thinking, hey, I use more than one…
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…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

737 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