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.