Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

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

Posted on 2003-10-30
7
4,039 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
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.

 
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: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering 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

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/…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

856 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