ASP page run time error

C

Cinderella

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
 
T

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.
==============================================


Cinderella said:
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 = '" &
Click to expand...
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
Click to expand...
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?
 
M

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


Cinderella said:
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,
Click to expand...
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?
 
Top