aspose file tools*
The moose likes JForum and the fly likes JForum with SQL Server Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Soft Skills this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "JForum with SQL Server" Watch "JForum with SQL Server" New topic
Author

JForum with SQL Server

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Hello,

I am trying to install JForum using MS SQL Server. I read all the previous posts on issues related to SQL Server and came to the conclusion that it is possible to configure JForum with sqlserver. I read this post

http://www.coderanch.com/t/575976

and tried to follow his steps. I got the source from CVS and built it. However I'm still getting this error:

Error while trying to configure the database. Please check if parameters like username, password and host are correct and try again.
net.sourceforge.jtds.jdbc.Driver

Please guide me how I should get JForum running with SQL Server.

Thanks,
Deb
[originally posted on jforum.net by dghosh]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I finally got JForum working with SQL Server, but seems like the sqlserver.sql file that I used is not free from bugs. For example, I can't see the "Member Listing" page- it displays

" An error has occurred.

For detailed error information, please see the HTML source code, and contact the forum Administrator.

Incorrect syntax near the keyword 'DECLARE'. "

Any help?

Thanks,
Deb


[originally posted on jforum.net by dghosh]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Yes, there may be some problems with the sql sintax. You will have to fix it yourself, as we don't have currently anyone supporting the sql server version

Rafael
[originally posted on jforum.net by Rafael Steil]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
dghosh, you can share your work? ops: please!

because i'don need of 'members list',

i need only: search (topics), Recent T�pics, My Profile, Private Messages, Home.

how it: http://www.subwaylan.com/forums/list.page (jforum (version:"old") + sql server 2000)

members list bug: http://www.subwaylan.com/user/list.page (but it is not problem for me)

thanks.
[originally posted on jforum.net by anacleto]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: JForum with SQL Server