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

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)
http://www.ycoln-resources.com
FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Cinderella" <(E-Mail Removed)> wrote in message
news:88F2B8BF-F513-4851-85EE-(E-Mail Removed)...
> 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
>

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" <(E-Mail Removed)> wrote in message news:88F2B8BF-F513-4851-85EE-(E-Mail Removed)...
> 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
>

Thanks! I solved the problem.