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?