powered by Jive Software

SQL Server 2005 URL

It appears the default connection URL that Jive Messenger uses to connect to SQL Server 2005 is incorrect.

The default is:

jdbc:sqlserver://[HOST_NAME]:[PORT_NUMBER]/database=[DB_NAME]

What works is:

jdbc:sqlserver://[HOST_NAME]:[PORT_NUMBER];databaseName=[DB_NAME]

My specs:

Jive Messenger 2.3.0

SQL Server 2005

SQL Server 2005 JDBC Beta 2 Driver

Have you tried to connect to a named instance of SQL 05? If so what was the path you used? Thanks!

Caleb,

Thanks for the post. For 2.3.2, I’‘ve actually switched the docs to recommend using Free TDS. We also now bundle that driver and the setup tool includes it’'s URL.

Regards,

Matt

Yes, I noticed that driver in SVN, then I read up on it. It looks pretty impressive. I’'m going to switch my server over to it as soon as I can.