Difference between revisions of "Database Connectivity"

From PresenceWiki
Jump to: navigation, search
 
(20 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Database Connectivity
+
Presence can connect to just about every Relational Database that support either JDBC or ODBC, below are some examples of the connection parameters
  
Access
 
  
When connectiong to Access you can use the ODBC drivers
+
* [[Connecting To Access]]
 +
How to integrate Microsoft Access within Presence
  
use the sun.jdbc.odbc.JdbcOdbcDriver
+
* [[Connecting To SQL Server]]
 +
How to use Presence with Microsoft SQL Server
  
jdbc:odbc:yourdsn
+
* [[Connecting To AS400 / iSeries]]
 +
How to use Presence with your AS400 / iSeries
  
In windows, create a dsn by
+
* [[Connecting To Pointbase]]
ODBC Data Source Administrator
+
How to use Presence with Pointbase
System DSN name (in this case yourdsn)
+
  
SQL Server
+
* [[Connecting to Oracle]]
 +
How to use Presence to connect with your Oracle server or cluster
  
Presence Version 3.5.4 uses the java 1.5 JVM. The jars for this can be downloaded from:-
+
* [[Connecting to DB2]]
 +
Instructions on connecting to IBM's DB2 Server
  
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:-
+
* [[Connecting To HyperSQL (hsqldb)]]
 +
How to use Presence with Hyper SQL
  
sqljdbc4.jar
+
=== 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]]

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