Hi
I'm having big problem with my forums at http://www.daggerford.com/fate.
All was working well, using SQL Server 2005. However, I had a completely unrelated problem yesterday that required me to uninstall SQL Server 2005. When I reinstalled SQL Server I reattached the database and created the user that's used for the forums connection. When I try to access the forums now I get numberous problems:
- none of the gaphics display. No idea why. The IIS anonymous user account has NTFS permissions to the files, but when I try to access a graphics file directly I get 404s.
- When I click on the link to the Generral forum I get:
ADODB.Recordset error '800a0bb9'
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/fate/forum.asp, line 335
Line 335 is highlighted in the code snippet below:
set rs = Server.CreateObject("ADODB.Recordset")
rs.cachesize = strPageSize
rs.open strSql & strSql2 & strSql3 & strSql4, my_Conn, adOpenStatic
if not rs.EOF then
rs.movefirst
rs.pagesize = strPageSize
inttotaltopics = cLng(rs.recordcount)
rs.absolutepage = mypage '**
maxpages = cLng(rs.pagecount)
arrTopicData = rs.GetRows(strPageSize)
iTopicCount = UBound(arrTopicData, 2)
else
iTopicCount = ""
inttotaltopics = 0
end if
rs.Close
set rs = nothing
end if
Anyone any idea what's gone wrong?
Roy
Topic Locked
Posted - 11 March 2006 : 15:59:14
.