[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

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

Posted on 2003-10-30
7
Medium Priority
?
4,263 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 750 total points
ID: 9651584
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Have you ever needed to get an ASP script to wait for a while? I have, just to let something else happen. Or in my case, to allow other stuff to happen while I was murdering my MySQL database with an update. The Original Issue This was written…
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/…
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 anti-spam), the admin…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses
Course of the Month19 days, 13 hours left to enroll

873 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