Difference between revisions of "Database Connectivity"

From PresenceWiki
Jump to: navigation, search
 
(12 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
== Microsoft Access ==
+
Presence can connect to just about every Relational Database that support either JDBC or ODBC, below are some examples of the connection parameters
  
−
When connectiong to Access you can use the ODBC drivers
 
  
−
First create an odbc connection from Administrative Tools - Data Sources (ODBC)
+
* [[Connecting To Access]]
 +
How to integrate Microsoft Access within Presence
  
−
http://www.international-presence.com/images/docs/jdbc/odbcdetails.png
+
* [[Connecting To SQL Server]]
 +
How to use Presence with Microsoft SQL Server
  
−
http://www.international-presence.com/images/docs/jdbc/odbclist.png
+
* [[Connecting To AS400 / iSeries]]
 +
How to use Presence with your AS400 / iSeries
  
−
After this create an SQL resource in Presence, with the following settings:-
+
* [[Connecting To Pointbase]]
 +
How to use Presence with Pointbase
  
−
http://www.international-presence.com/images/docs/jdbc/accessdetails.png
+
* [[Connecting to Oracle]]
 +
How to use Presence to connect with your Oracle server or cluster
  
−
Note, the driver class is sun.jdbc.odbc.JdbcOdbcDriver
+
* [[Connecting to DB2]]
−
and the connection url is jdbc:odbc:yourdsn
+
Instructions on connecting to IBM's DB2 Server
  
−
Hit test, to check the connection:-
+
* [[Connecting To HyperSQL (hsqldb)]]
 +
How to use Presence with Hyper SQL
  
−
http://www.international-presence.com/images/docs/jdbc/accessconnect.png
+
=== Further Reading ===
  
−
You can then use this resource in the SQL node.
+
For more info on how to create the database connection see [[Database Resource]]
  
−
http://www.international-presence.com/images/docs/jdbc/accessresults.png
+
For an overview of the SQL Node that we use to run SQL statements see [[SQL Statement Nodes]]
−
 
+
−
== Microsoft SQL Server ==
+
−
 
+
−
http://www.international-presence.com/images/docs/jdbc/sqlserverdetails.png
+
−
 
+
−
Driver class
+
−
com.microsoft.sqlserver.jdbc.SQLServerDriver
+
−
 
+
−
Connection URL
+
−
jdbc:sqlserver://ServerName:1433:databaseName=MyDatabase;
+
−
 
+
−
http://www.international-presence.com/images/docs/jdbc/sqlconnect.png
+
−
 
+
−
http://www.international-presence.com/images/docs/jdbc/sqlresults.png
+
−
 
+
−
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
+
−
 
+
−
As the Presence Jar Manager caches the classes you should restart the server if you have changed the
+
−
location of a class.
+

Latest revision as of 14:14, 12 August 2015

Presence can connect to just about every Relational Database that support either JDBC or ODBC, below are some examples of the connection parameters


How to integrate Microsoft Access within Presence

How to use Presence with Microsoft SQL Server

How to use Presence with your AS400 / iSeries

How to use Presence with Pointbase

How to use Presence to connect with your Oracle server or cluster

Instructions on connecting to IBM's DB2 Server

How to use Presence with Hyper SQL

Further Reading

For more info on how to create the database connection see Database Resource

For an overview of the SQL Node that we use to run SQL statements see SQL Statement Nodes

Retrieved from "https://www.international-presence.com/wikidocs/index.php?title=Database_Connectivity&oldid=5731"