Difference between revisions of "Database Connectivity"

From PresenceWiki
Jump to: navigation, search
Line 4: Line 4:
  
 
When connectiong to Access you can use the ODBC drivers
 
When connectiong to Access you can use the ODBC drivers
 
+
odbcdetails
 
http://www.international-presence.com/images/docs/jdbc/odbcdetails.png  
 
http://www.international-presence.com/images/docs/jdbc/odbcdetails.png  
 
+
odbclist
 
http://www.international-presence.com/images/docs/jdbc/odbclist.png  
 
http://www.international-presence.com/images/docs/jdbc/odbclist.png  
 
+
accessconnect
 
http://www.international-presence.com/images/docs/jdbc/accessconnect.png  
 
http://www.international-presence.com/images/docs/jdbc/accessconnect.png  
 
+
accessdetails
 
http://www.international-presence.com/images/docs/jdbc/accessdetails.png  
 
http://www.international-presence.com/images/docs/jdbc/accessdetails.png  
 
+
accessdetails2
 
http://www.international-presence.com/images/docs/jdbc/accessdetails2.png  
 
http://www.international-presence.com/images/docs/jdbc/accessdetails2.png  
 
+
accessresults
 
http://www.international-presence.com/images/docs/jdbc/accessresults.png  
 
http://www.international-presence.com/images/docs/jdbc/accessresults.png  
 
+
sqlconnect
 
http://www.international-presence.com/images/docs/jdbc/sqlconnect.png  
 
http://www.international-presence.com/images/docs/jdbc/sqlconnect.png  
 
+
sqlserverdetails
 
http://www.international-presence.com/images/docs/jdbc/sqlserverdetails.png  
 
http://www.international-presence.com/images/docs/jdbc/sqlserverdetails.png  
 
+
sqlresults
 
http://www.international-presence.com/images/docs/jdbc/sqlresults.png  
 
http://www.international-presence.com/images/docs/jdbc/sqlresults.png  
  

Revision as of 18:06, 2 January 2010

Database Connectivity

Access

When connectiong to Access you can use the ODBC drivers odbcdetails http://www.international-presence.com/images/docs/jdbc/odbcdetails.png odbclist http://www.international-presence.com/images/docs/jdbc/odbclist.png accessconnect http://www.international-presence.com/images/docs/jdbc/accessconnect.png accessdetails http://www.international-presence.com/images/docs/jdbc/accessdetails.png accessdetails2 http://www.international-presence.com/images/docs/jdbc/accessdetails2.png accessresults http://www.international-presence.com/images/docs/jdbc/accessresults.png sqlconnect http://www.international-presence.com/images/docs/jdbc/sqlconnect.png sqlserverdetails http://www.international-presence.com/images/docs/jdbc/sqlserverdetails.png sqlresults 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