JTDS Implementation question

Chris2 · March 22, 2005, 7:22pm

has anyone tried to implement the JTDS java driver for SQL Server 7?

how do you do this?

Josh · March 22, 2005, 8:20pm

I’'m using the default driver for SQL Server 2000 as described in the installation instructions on SQL Server 7 and it works fine.

Have you tried that one?

matt · March 22, 2005, 9:45pm

BTW, if you do use JTDS and find that it works well, please let us know!

-Matt

Chris2 · March 23, 2005, 10:28pm

I have tried it but I don’'t have the microsoft java driver that apparently comes with sql server 2000

Ryan_Graham · March 23, 2005, 10:37pm

Looks like you can download it url=http://www.microsoft.com/downloads/details.aspx?FamilyID=9f1874b6-f8e1-4bd6- 947c-0fc5bf05bf71&displaylang=enhere[/url].

Hope that helps,

Ryan

Chris2 · March 24, 2005, 11:39pm

I was unable to get the JDBC driver (SP3) from Microsoft to work with SQL Server 7.

I was able to get the JTDS driver to work.

Place the JTDS jar file in the lib directory of Jive Messenger
Re-start the Jive Messenger server software
JDBC Driver Class: net.sourceforge.jtds.jdbc.Driver
Database URL: jdbc:jtds:<server_type>://[:][/][;=[;… .]]

The driver is available from http://jtds.sourceforge.net/

Hope this helps others!

matt · March 24, 2005, 11:55pm

Thanks for the info! I added it to the docs for the next release.

-Matt