Difference between revisions of "Database Connectivity"

From PresenceWiki
Jump to: navigation, search
 
(10 intermediate revisions by 3 users not shown)
Line 1: Line 1:
−
==[[Connecting To Access]]==
+
Presence can connect to just about every Relational Database that support either JDBC or ODBC, below are some examples of the connection parameters
−
Tips on Organising your Categories and Tasks
+
  
−
==[[Connecting To SQL Server]]==
 
−
Better Task Design
 
  
 +
* [[Connecting To Access]]
 +
How to integrate Microsoft Access within Presence
  
−
== Microsoft Access ==
+
* [[Connecting To SQL Server]]
 +
How to use Presence with Microsoft SQL Server
  
−
When connectiong to Access you can use the ODBC drivers
+
* [[Connecting To AS400 / iSeries]]
 +
How to use Presence with your AS400 / iSeries
  
−
First create an odbc connection from Administrative Tools - Data Sources (ODBC)
+
* [[Connecting To Pointbase]]
 +
How to use Presence with Pointbase
  
−
http://www.international-presence.com/images/docs/jdbc/odbcdetails.png
+
* [[Connecting to Oracle]]
 +
How to use Presence to connect with your Oracle server or cluster
  
−
http://www.international-presence.com/images/docs/jdbc/odbclist.png
+
* [[Connecting to DB2]]
 +
Instructions on connecting to IBM's DB2 Server
  
−
After this create an SQL resource in Presence, with the following settings:-
+
* [[Connecting To HyperSQL (hsqldb)]]
 +
How to use Presence with Hyper SQL
  
−
http://www.international-presence.com/images/docs/jdbc/accessdetails.png
+
=== Further Reading ===
  
−
Note, the driver class is sun.jdbc.odbc.JdbcOdbcDriver
+
For more info on how to create the database connection see [[Database Resource]]
−
and the connection url is jdbc:odbc:yourdsn
+
  
−
Hit test, to check the connection:-
+
For an overview of the SQL Node that we use to run SQL statements see [[SQL Statement Nodes]]
−
 
+
−
http://www.international-presence.com/images/docs/jdbc/accessconnect.png
+
−
 
+
−
You can then use this resource in the SQL node.
+
−
 
+
−
http://www.international-presence.com/images/docs/jdbc/accessresults.png
+
−
 
+
−
== 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 which in turn will need the sqljdbc.jar
+
−
 
+
−
Presence Version 3.5.5 uses the java 1.6 JVM which in turn uses 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"