Difference between revisions of "Connecting To SQL Server"

Revision as of 19:29, 2 January 2010

Microsoft SQL Server

http://www.international-presence.com/images/docs/jdbc/sqlserverdetails.png

Driver class com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection URL jdbc:sqlserver://ServerName:1433:databaseName=MyDatabase;

http://www.international-presence.com/images/docs/jdbc/sqlconnect.png

http://www.international-presence.com/images/docs/jdbc/sqlresults.png

Presence Version 3.5.4 uses the java 1.5 JVM which in turn will need the sqljdbc.jar

Presence Version 3.5.5 uses the java 1.6 JVM which in turn uses sqljdbc4.jar

As the Presence Jar Manager caches the classes you should restart the server if you have changed the location of a class.