Solved

ASP.  Response Object,80020003.      Missing Default Property~0185~

Posted on 2003-10-30
7
4,064 Views
Last Modified: 2012-08-13
Please tell me what could be wrong with the following. It returns an following error message:
Response object, 8002003, ASP 0185~Missing Default Property~A default property was not found for the object.

I am using MySQL as you can see and it works fine on my local machine, but not on with database on hosting server wich is the same - MySQL.

If you can think of any solution, I'd appreciate it. Thanks.

_______________________code___________________________

<%
dim conn,rs,x
set conn=Server.CreateObject('ADODB.Connection')
set rs=Server.CreateObject('ADODB.Recordset')
conn.open 'Driver={mySQL ODBC 3.51 Driver};Server=localhost;database=Name; password=****** ; uid=Bluh'

rs.open 'SELECT *  FROM Person Where Active=0 Order By LastLogin; ', conn
%>

..........
..........

<%
for each x in rs.Fields
      response.write('<th>' & ucase(x.name) & '</th>')  
next
%>
</tr>
<%do until rs.EOF%>
0
Comment
Question by:shmoel
7 Comments
 
LVL 21

Expert Comment

by:ap_sajith
ID: 9651573
try

for each x in rs.Fields
     response.write("<th>" & ucase(x.name) & "</th>")  
next


Cheers!!
0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 9651582
Give this a shot:

rs.open "SELECT *  FROM Person Where Active=0 Order By LastLogin;",conn,3,3
do while not rs.eof
      for each x in rs.Fields
            response.write("<th>" & ucase(x.name) & "</th>")  
      next
loop

FtB
0
 
LVL 29

Accepted Solution

by:
David H.H.Lee earned 250 total points
ID: 9651584
0
Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 9651670
Which may be the case when using ' as a delimiter instead of "

FtB
0
 

Author Comment

by:shmoel
ID: 9653475
I think I found the reason - link provided by FtB was very helpfull.
Thank you.
I got connected to my DB, but I am still not sure how would I split my x.name and x.value. I am getting in both- heading and body of my result table only field names. Well, thanks to everybody anyway.
 
0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 9653485
I don't understand the last part, what do you need to do?

FtB
0
 
LVL 46

Expert Comment

by:fritz_the_blank
ID: 9653491
I am totally confused now--what solved the problem?

FtB
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Javascript to allow login/password authorization 4 60
edit .asp files 5 48
Weighted Randomizing 6 33
Can't select treeview node from iframe 2 38
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 demonstration started out as a follow up to some recently posted questions on the subject of logging in: http://www.experts-exchange.com/Programming/Languages/Scripting/JavaScript/Q_28634665.html and http://www.experts-exchange.com/Programming/…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

733 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