Difference between revisions of "Database Connectivity"
Line 4: | Line 4: | ||
When connectiong to Access you can use the ODBC drivers | When connectiong to Access you can use the ODBC drivers | ||
+ | |||
+ | http://www.international-presence.com/images/docs/jdbc/odbcdetails.png | ||
+ | |||
+ | http://www.international-presence.com/images/docs/jdbc/odbclist.png | ||
+ | |||
+ | http://www.international-presence.com/images/docs/jdbc/accessconnect.png | ||
+ | |||
+ | http://www.international-presence.com/images/docs/jdbc/accessdetails.png | ||
+ | |||
+ | http://www.international-presence.com/images/docs/jdbc/accessdetails2.png | ||
+ | |||
+ | http://www.international-presence.com/images/docs/jdbc/accessresults.png | ||
+ | |||
+ | http://www.international-presence.com/images/docs/jdbc/sqlconnect.png | ||
+ | |||
+ | http://www.international-presence.com/images/docs/jdbc/sqlserverdetails.png | ||
+ | |||
+ | http://www.international-presence.com/images/docs/jdbc/sqlresults.png | ||
+ | |||
Driver class | Driver class |
Revision as of 18:05, 2 January 2010
Database Connectivity
Access
When connectiong to Access you can use the ODBC drivers
http://www.international-presence.com/images/docs/jdbc/odbcdetails.png
http://www.international-presence.com/images/docs/jdbc/odbclist.png
http://www.international-presence.com/images/docs/jdbc/accessconnect.png
http://www.international-presence.com/images/docs/jdbc/accessdetails.png
http://www.international-presence.com/images/docs/jdbc/accessdetails2.png
http://www.international-presence.com/images/docs/jdbc/accessresults.png
http://www.international-presence.com/images/docs/jdbc/sqlconnect.png
http://www.international-presence.com/images/docs/jdbc/sqlserverdetails.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