Solved

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

Posted on 2003-10-30
7
4,010 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

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

I have helped a lot of people on EE with their coding sources and have enjoyed near about every minute of it. Sometimes it can get a little tedious but it is always a challenge and the one thing that I always say is:  The Exchange of information …
Hello, all! I just recently started using Microsoft's IIS 7.5 within Windows 7, as I just downloaded and installed the 90 day trial of Windows 7. (Got to love Microsoft for allowing 90 days) The main reason for downloading and testing Windows 7 is t…
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …

770 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