JForum with SQL Server

[Migrated From Jforum.net]

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

https://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]

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]

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]

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]