ASP page run time error

[Guest]

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 = " & forumi
cn.execute = "UPDATE disc_topics SET last_user_id = " & session("user_id") & ", datelast = '" & now & "', replies = replies + 1 WHERE topicid = " & topici

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

Cinderell

 

[Thomas A. Rowe]

Have you contacted the author of your forum application for help regarding the conversion from
Access to MS SQL server?

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================

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?

 

[MD Websunlimited]

Hi,

Have you contacted the authors of the forum system? This question is not related to FP.

--
Mike -- FrontPage MVP '97 - '02
http://www.websunlimited.com

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?

 

[Guest]

Thanks! I solved the problem.