Difference between revisions of "Database Connectivity"
From PresenceWiki
| Line 1: | Line 1: | ||
Database Connectivity | Database Connectivity | ||
| + | |||
| + | Access | ||
When connectiong to Access you can use the ODBC drivers | 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.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:- | 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:- | ||
Revision as of 16:53, 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:-
