SQL Server 2005 URL

Caleb_Anthony · November 28, 2005, 11:19pm

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

Bruce · December 10, 2005, 9:04pm

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

matt · December 13, 2005, 6:01am

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

Caleb_Anthony · December 13, 2005, 3:37pm

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.