Difference between revisions of "Connecting To SQL Server"
From PresenceWiki
Line 1: | Line 1: | ||
− | |||
− | |||
http://www.international-presence.com/images/docs/jdbc/sqlserverdetails.png | http://www.international-presence.com/images/docs/jdbc/sqlserverdetails.png | ||
Revision as of 19:29, 2 January 2010
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.