Unspecified Error

[artsapimp]

error '80004005'
Unspecified error

/nhd/view1.asp, line 18

That is what I'm getting when trying to run a query from a database. The query runs fine in Access, I just import it out to ASP and call it my strSQL and now it's giving me this error. Here is my strSQL, please tell me what I'm doing wrong. Thanks.

strSQL = "SELECT Evaluations.RecordID, Evaluator.Evaluator, Member.Member, Title.Title, Evaluations.Evaluation_Date, Evaluations.Greeting, Evaluations.Verification, Evaluations.Probing, Evaluations.Control, Evaluations.Language, Evaluations.Courtesy, Evaluations.Accuracy, Evaluations.Problem, Evaluations.Transition, Evaluations.Retention, Evaluations.Ethics, Evaluations.Explain, Evaluations.Score"
strSQL = strSQL & " FROM Title RIGHT JOIN (Member RIGHT JOIN (Evaluator RIGHT JOIN Evaluations ON Evaluator.EvaluatorID = Evaluations.Evaluator) ON Member.MemberID = Evaluations.Member) ON Title.TitleID = Evaluations.Title"
strSQL = strSQL & " WHERE Evaluations.RecordID = " & Request.QueryString("Record")

Thanks for any help.

[harsoni]

I don't see any problem in the above code...


Sonia

[Imanta]

IIS is really a big help with these eh?

Most of the time I have had this problem it is usually is corrected by a fresh install of the newest MDAC from Microsoft. This would be my first guess...

Also, can we see the Connection String (is it using a DSN, or is it DSNless)?

[compuGEEK]

Perhaps this will help you out a bit:

http://support.microsoft.com/support.../q237/5/36.asp

[artsapimp]

That was so close. Thank you. It seems that solution is referring to the error when you're trying to append or write to the DB. The writing portion is working fine, it's the reading that is giving me the problem.

Any other suggestions will be greatly appreciated.

[nybble]

you are gonna hate me for saying this...
but did you make a typo?

those weird errors often come up when IIS can't find something.

[artsapimp]

No, I don't hate you for saying that. I am very happy to hear any suggestions.

The only reason I can say I didn't make a typo is because I made the query in Access. I then copied and pasted it into the ASP page. It is impossible for something to get misspelled while I'm doing that right?

[nybble]

hehe. microsoft is capable of many things.

what is content of the line that gets the error?

also, what is the connect string?

[artsapimp]

ConnectString is.....

ConnectString = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = " & Server.MapPath("database/evaluations.mdb")

The page says error in line 1, which I have found usually means the strSQL. That is posted above if you want to see it.

Thanks again, keep 'em coming.

[nybble]

hop on your aol instant messanger and lets figure this out.

[artsapimp]

I'm at work and don't have IM. I can post more information if you want to try it.

[nybble]

go for it.

[artsapimp]

let me strip all of the proprietary stuff from the pages I could lose my job for and I will post the zip file.

[artsapimp]

Here it is. I included the db also so everything should work the same on your side as it does on mine.

Please, please, please find something I have done wrong. Thanks.

If you need to contact me you can at [email protected].