Print Page | Close Window

Error : Response oject error, help..

Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=1125
Printed Date: 29 March 2026 at 3:11am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com


Topic: Error : Response oject error, help..
Posted By: woodja
Subject: Error : Response oject error, help..
Date Posted: 18 March 2003 at 6:18pm

I'm trying to recieve values from an access database, and this is the error message i get :

Response object error 'ASP 0185 : 8002000e'

Missing Default Property

/woodya/PicRate.asp, line 0

A default property was not found for the object.

I've tried alot to fix it, can't figure it out, but her is the code :

<%
dim conn, lpicid, lpicrate, lpicavg, filepath, rspic

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

filepath = Server.MapPath("/woodya/db/LDBPIC.mdb")
conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & FilePath & ";"

lpicid = conn.execute ("SELECT lphotoid FROM tbllastpic WHERE id = 99")
lpicrate = conn.execute ("SELECT lphotorate FROM tbllastpic WHERE id = 99")
lpicavg = conn.execute ("SELECT lphotoavg FROM tbllastpic WHERE id = 99")
 %>

Any help, would be great, thanks in advance.




Replies:
Posted By: MorningZ
Date Posted: 18 March 2003 at 8:15pm
<%
dim conn, lpicid, lpicrate, lpicavg, filepath, rspic

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

filepath = Server.MapPath("/woodya/db/LDBPIC.mdb")
conn.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & FilePath & ";"

Set lpicid = conn.execute ("SELECT lphotoid FROM tbllastpic WHERE id = 99")
Set lpicrate = conn.execute ("SELECT lphotorate FROM tbllastpic WHERE id = 99")
Set lpicavg = conn.execute ("SELECT lphotoavg FROM tbllastpic WHERE id = 99")
%>


-------------
Contribute to the working anarchy we fondly call the Internet


Posted By: woodja
Date Posted: 19 March 2003 at 11:42am
Thank You for replying but still no luck, any other ideas.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net