Difference between revisions of "Database Connectivity"

Revision as of 16:56, 30 December 2009

Database Connectivity

Access

When connectiong to Access you can use the ODBC drivers

use the sun.jdbc.odbc.JdbcOdbcDriver

jdbc:odbc:yourdsn

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

SQL Server

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

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

Revision as of 16:53, 30 December 2009 (view source) Graham (Talk \| contribs) ← Previous diff		Revision as of 16:56, 30 December 2009 (view source) Graham (Talk \| contribs) Next diff →
Line 18:		Line 18:

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