Difference between revisions of "Connecting To Access"

From PresenceWiki
Jump to: navigation, search
 
Line 8: Line 8:
 
Create a new DSN, give it a name and then browse to your mdb file.
 
Create a new DSN, give it a name and then browse to your mdb file.
  
http://www.international-presence.com/images/docs/jdbc/odbcdetails.png  
+
[[file:odbcdetails.png]]
  
 
After this you will see your newly created connection in the list of DSNs
 
After this you will see your newly created connection in the list of DSNs
  
http://www.international-presence.com/images/docs/jdbc/odbclist.png  
+
[[file:odbclist.png]]
  
 
Now you should create a new SQL Database Resource in Presence, with the following settings:-
 
Now you should create a new SQL Database Resource in Presence, with the following settings:-
  
http://www.international-presence.com/images/docs/jdbc/accessdetails.png  
+
[[file:accessdetails.png]]
  
 
Note, the driver class is sun.jdbc.odbc.JdbcOdbcDriver
 
Note, the driver class is sun.jdbc.odbc.JdbcOdbcDriver
Line 26: Line 26:
 
Hit test, to check the connection:-
 
Hit test, to check the connection:-
  
http://www.international-presence.com/images/docs/jdbc/accessconnect.png  
+
[[file:accessconnect.png]]
  
 
You can then use this resource in the SQL node.
 
You can then use this resource in the SQL node.
  
http://www.international-presence.com/images/docs/jdbc/accessresults.png
+
[[file:accessresults.png]]
  
  
 
{{DatabaseConnectivityHeader}}
 
{{DatabaseConnectivityHeader}}

Latest revision as of 08:53, 21 August 2015

Database Connectivity > Connecting To Access


When connectiong to Access you can use the ODBC drivers

First create an odbc connection from Administrative Tools - Data Sources (ODBC)

Create a new DSN, give it a name and then browse to your mdb file.

Odbcdetails.png

After this you will see your newly created connection in the list of DSNs

Odbclist.png

Now you should create a new SQL Database Resource in Presence, with the following settings:-

Accessdetails.png

Note, the driver class is sun.jdbc.odbc.JdbcOdbcDriver

The class sun.jdbc.odbc.JdbcOdbcDriver is part of the JRE so you should not have to import any external jars.

The connection url is jdbc:odbc:yourdsn

Hit test, to check the connection:-

Accessconnect.png

You can then use this resource in the SQL node.

Accessresults.png


Database Connectivity > Connecting To Access