asked on

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

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%>

ap_sajith

try

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

Cheers!!

fritz_the_blank

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

ASKER CERTIFIED SOLUTION

David H.H.Lee

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

fritz_the_blank

Which may be the case when using ' as a delimiter instead of "

FtB

shmoel

ASKER

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.

fritz_the_blank

I don't understand the last part, what do you need to do?

FtB

fritz_the_blank

I am totally confused now--what solved the problem?

FtB