One of the big headache's with MS SQL is that it has never supported the non-standard / but widely supported by other vendor's LIMIT and OFFSET type of syntax. These are generally used to get a subset (e.g. page) of results from a large query. The current SQL support "emulates" these using the SQL 2005 functions.
That said, there are two way to go here. The first is to try to figure out a way to emulate the OFFSET/LIMIT functions in older MS SQL versions. This might require some server specific stored procedures or views to be set up and the associated queries to be changed.
Or, if you don't mind running the 2.1.6 version, you could use my Torque DAO implimentation. See:
i am successfully install with version 2.1.6 with dao on local,
but that version can not host on the web, because first, i do not have the war file, second if i have the war file, can not edit the jforum-custom.conf on the server
So, i have tried the latest version 2.1.7 b3, It doesn't work, problem with
systemglobal.properties (connect to databse error, something like that), when i start the site, after fix the error in log4.xml ( no appender could be found )
So, can you help me fix the problem or i have to wait for the next version [originally posted on jforum.net by kiemhao]
A war is nothing more that a zip file/jar file of everything under the webapp's root directory (e.g. the one that the WEB-INF file is in).
If you have a working local version, just make sure the jforum-custom.conf has the values you need for the production server and zip it up. I.e., if you expand a war file with winzip or 7zip, the directory that you expand it to will contains stuff like:
As opposed to jforum/images, etc.
One thing I'm not sure of is if JForum will run correctly from an unexpanded war file. In particular, attachments may not have a place to be stored. [originally posted on jforum.net by monroe]