I'm upgrading from 7.x to 9.08 and things are working well. I found a few issues with the upgrader and I will send along my fixes after finishing everything up.
The main problem I'm having is that when I try to reply to a post I get this error every time:
Microsoft OLE DB Provider for SQL Server error '80040e31'
Timeout expired
/forum908/new_post.asp, line 787
|
That's where it opens this query.........
strSQL = "SELECT" & strDBTop1 & " " & strDbTable & "Thread.* " & _
"FROM " & strDbTable & "Thread" & strRowLock & " " & _
"ORDER BY " & strDbTable & "Thread.Thread_ID DESC" & strDBLimit1 & ";"
.....with......
'Open the threads table
.Open strSQL, adoCon <----- Line 787
Everything else seems to run really well and it seems a lot faster than 7.x. I ran this query directly on the SQL server and didn't have any problem processing it directly. Does this ring any bells for anyone?
Topic Options
Post Options
Thanks(0)
