Solved

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

Posted on 2003-10-30
7
3,988 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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

I would like to start this tip/trick by saying Thank You, to all who said that this could not be done, as it forced me to make sure that it could be accomplished. :) To start, I want to make sure everyone understands the importance of utilizing p…
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/…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…

895 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now