Database Connectivity
Microsoft Access
When connectiong to Access you can use the ODBC drivers
First create an odbc connection from Administrative Tools - Data Sources (ODBC)
http://www.international-presence.com/images/docs/jdbc/odbcdetails.png
http://www.international-presence.com/images/docs/jdbc/odbclist.png
After this create an SQL resource in Presence, with the following settings:-
http://www.international-presence.com/images/docs/jdbc/accessdetails.png
Note, the driver class is sun.jdbc.odbc.JdbcOdbcDriver and the connection url is jdbc:odbc:yourdsn
Hit test, to check the connection:-
http://www.international-presence.com/images/docs/jdbc/accessconnect.png
You can then use this resource in the SQL node.
http://www.international-presence.com/images/docs/jdbc/accessresults.png
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.