DeskNow Knowledge Base
 
      
Home Backup and migration How do I upgrade the JDBC driver for MS SQL Server?

How do I upgrade the JDBC driver for MS SQL Server?

If you first installed DeskNow before 2006 and are using SQL Server as database, you are likely to be using the old JDBC driver from Microsoft.

Microsoft has since released a completely new driver, much faster and memory efficient.

To check if you're still using the old driver

If you're using the old driver, you should have these files in \desknowdata\lib: mssqlserver.jar, msutil.jar, msbase.jar

If you're still using the old driver, and want to upgrade

  1. stop DeskNow
  2. download and install the new driver from http://msdn.microsoft.com/data/jdbc/default.aspx
  3. copy the sqljdbc.jar file to \desknowdata\lib
  4. delete the mssqlserver.jar, msutil.jar, msbase.jar files from \desknowdata\lib (or move them to a backup folder)
  5. edit the Database.cfg configuration file and change these settings:
    JdbcDriver  com.microsoft.sqlserver.jdbc.SQLServerDriver
    Url   jdbc:sqlserver://localhost:1433;forwardReadOnlyMethod=serverCursor;loginTimeout=30;DatabaseName=desknow
    Username  desknowserver
    Password  password
  6. restart DeskNow

Note: the JdbcDriver parameter is different from the parameter used for the old driver (it was com.microsoft.jdbc, now it is com.microsoft.sqlserver).

 

Email Article Email
Print Article Print


How helpful was this article to you?
Related Articles
article How do I make the DeskNow service start after the database server?
This article applies to Windows environments...

  May 27, 2004    Views: 63685   
article Could not connect to the remote mail server
This is another case of the following problem:...

(No rating)  April 15, 2008    Views: 17292   
article Could not connect to the remote mail server
This is another case of this error:...

  April 12, 2006    Views: 19022   



Powered by Lore :: (c)2003 Pineapple Technologies.