Difference between revisions of "Database Connectivity"

Revision as of 18:29, 2 January 2010

Database Connectivity

--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

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

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

--SQL Server

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

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

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

Driver class use the sun.jdbc.odbc.JdbcOdbcDriver

Connection URL jdbc:odbc:yourdsn

In windows, create a dsn by ODBC Data Source Administrator System DSN name (in this case yourdsn)

SQL Server

Driver class com.microsoft.sqlserver.jdbc.SQLServerDriver

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

Presence Version 3.5.4 uses the java 1.5 JVM. The jars for this can be downloaded from:-

sqljdbc.jar

then added via the jar manager which should point to

Presence Version 3.5.5 uses the java 1.6 JVM. Because of this, if you are using SQLServer connections you will need to use the appropriate jars:-

sqljdbc4.jar

then added via the jar manager which should point to