Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - Error on access to sql conversion
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Error on access to sql conversion

 Post Reply Post Reply
Author
joshb View Drop Down
Groupie
Groupie


Joined: 26 June 2002
Location: United States
Status: Offline
Points: 134
Post Options Post Options   Thanks (0) Thanks(0)   Quote joshb Quote  Post ReplyReply Direct Link To This Post Topic: Error on access to sql conversion
    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.
Back to Top
joshb View Drop Down
Groupie
Groupie


Joined: 26 June 2002
Location: United States
Status: Offline
Points: 134
Post Options Post Options   Thanks (0) Thanks(0)   Quote joshb Quote  Post ReplyReply Direct Link To This Post Posted: 01 July 2003 at 12:10pm
Nothing? No one has an idea?

Edited by joshb
I'm a wannabe programmer that knows how to do nothing but create invalid procedure arguments.
Back to Top
MadDog View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 01 January 2002
Status: Offline
Points: 3008
Post Options Post Options   Thanks (0) Thanks(0)   Quote MadDog Quote  Post ReplyReply Direct Link To This Post Posted: 01 July 2003 at 12:12pm
Remove "TOP 1" from the SQL statement.
Back to Top
joshb View Drop Down
Groupie
Groupie


Joined: 26 June 2002
Location: United States
Status: Offline
Points: 134
Post Options Post Options   Thanks (0) Thanks(0)   Quote joshb Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
the boss View Drop Down
Senior Member
Senior Member
Avatar

Joined: 19 January 2003
Location: Saudi Arabia
Status: Offline
Points: 1727
Post Options Post Options   Thanks (0) Thanks(0)   Quote the boss Quote  Post ReplyReply Direct Link To This Post Posted: 01 July 2003 at 2:09pm
just grab the sql version of the wwgf v6.34 ad install it right away!!
Back to Top
joshb View Drop Down
Groupie
Groupie


Joined: 26 June 2002
Location: United States
Status: Offline
Points: 134
Post Options Post Options   Thanks (0) Thanks(0)   Quote joshb Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.