I recently upgraded my ASP forum's backend database from Access to SQL Server.

I was trying to make a new posting, then got the following error:

Microsoft VBScript runtime error '800a01b6'

Object doesn't support this property or method: 'Execute'

/forum/forums.asp, line 1180

This is the code of the line:
cn.execute = "UPDATE disc_forums SET posts = posts + 1 WHERE forumid = " & forumid
cn.execute = "UPDATE disc_topics SET last_user_id = " & session("user_id") & ", datelast = '" & now & "', replies = replies + 1 WHERE topicid = " & topicid

I suspected in the beginning that there was some problem with my user account in conn. It has the right to insert, delete, update, and read. However, I couldn't give it right to execute. I tried to create a new user and it worked. Is there any syntax that would only work with ACCESS but not SQL SERVER here?

Thanks!

Cinderella

Change those 2 lines as given below.

cn.execute("UPDATE disc_forums SET posts = posts + 1 WHERE forumid = " & forumid)
cn.execute("UPDATE disc_topics SET last_user_id = " & session("user_id") & ", datelast = '" & now & "', replies = replies + 1 WHERE topicid = " & topicid)

Cheers!

_________________________
-Vijay G
Strive for Perfection

Happygv,

It's working! It's so cool! Thanks a lot for your help and have a nice weekend!

Cinderella