Web Wiz Forums - Error on access to sql conversion

Print Page | Close Window

Error on access to sql conversion

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=3972
Printed Date: 01 April 2026 at 11:29pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error on access to sql conversion

Posted By: joshb
Subject: Error on access to sql conversion
Date Posted: 01 July 2003 at 7:24am

I know this subject has been beaten to death but I actually have gotten the conversion done and pretty smotthly I must say except for 1 thing, well 1 thing I have found so far.

I am upgrading v6.34 of the forum to sql. Browsing the site it appears to be fine, but when I try to post a new topic it gives me an error as follows:

ADODB.Recordset (0x800A0CB3)
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
/forum/post_message.asp, line 277

Now I know this isn't correct because I didn't change the code and locktype is right anyways. Here is the surrounding code to the error.

'Intialise the ADO recordset object
Set rsNewTopic = Server.CreateObject("ADODB.Recordset")

'Initalise the SQL string with a query to get the Topic details
strSQL = "SELECT TOP 1 tblTopic.* FROM tblTopic "
strSQL = strSQL & "WHERE Forum_ID =" & intForumID & " "
strSQL = strSQL & "ORDER By tblTopic.Start_date DESC;"

'Set the cursor type property of the record set to Dynamic so we can navigate through the record set
rsNewTopic.CursorType = 2

'Set the Lock Type for the records so that the record set is only locked when it is updated
rsNewTopic.LockType = 3

'Open the author table
rsNewTopic.Open strSQL, strCon

'Insert the new topic details in the recordset
rsNewTopic.AddNew <--Line 277

So as you can see the code is right, and the driver I am using is the default sql driver that came with the forum.

Anyone, have ideas?

-------------
I'm a wannabe programmer that knows how to do nothing but create invalid procedure arguments.
http://www.soopportal.com">

Replies:

Posted By: joshb
Date Posted: 01 July 2003 at 12:10pm

Nothing? No one has an idea?

-------------
I'm a wannabe programmer that knows how to do nothing but create invalid procedure arguments.
http://www.soopportal.com">

Posted By: MadDog
Date Posted: 01 July 2003 at 12:12pm

Remove "TOP 1" from the SQL statement.

-------------
http://www.iportalx.net" rel="nofollow">

Posted By: joshb
Date Posted: 01 July 2003 at 12:32pm

Nop but your second suggestion of removing the order by has given me a new error message. I think now I just need to walk throug hand make sure default values are in the db. Access doesn't carry them over.

-------------
I'm a wannabe programmer that knows how to do nothing but create invalid procedure arguments.
http://www.soopportal.com">

Posted By: the boss
Date Posted: 01 July 2003 at 2:09pm

just grab the sql version of the wwgf v6.34 ad install it right away!!

Posted By: joshb
Date Posted: 01 July 2003 at 2:13pm

Well that wouldn't work. I have made so many changes to the db and I would need the data I have already in it anyways.

I assume you thought of that before you just blurted that answer out, right.

-------------
I'm a wannabe programmer that knows how to do nothing but create invalid procedure arguments.
http://www.soopportal.com">