Difference between revisions of "Connecting To Access"
From PresenceWiki
| (6 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | {{DatabaseConnectivityHeader}} | |
| + | |||
When connectiong to Access you can use the ODBC drivers | When connectiong to Access you can use the ODBC drivers | ||
| Line 5: | Line 6: | ||
First create an odbc connection from Administrative Tools - Data Sources (ODBC) | 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. | |
| − | + | [[file:odbcdetails.png]] | |
| − | After this | + | After this you will see your newly created connection in the list of DSNs |
| − | + | [[file:odbclist.png]] | |
| + | |||
| + | Now you should create a new SQL Database Resource in Presence, with the following settings:- | ||
| + | |||
| + | [[file:accessdetails.png]] | ||
Note, the driver class is sun.jdbc.odbc.JdbcOdbcDriver | 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:- | Hit test, to check the connection:- | ||
| − | + | [[file:accessconnect.png]] | |
You can then use this resource in the SQL node. | You can then use this resource in the SQL node. | ||
| − | + | [[file:accessresults.png]] | |
| + | |||
| + | |||
| + | {{DatabaseConnectivityHeader}} | ||
Latest revision as of 12: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.
After this you will see your newly created connection in the list of DSNs
Now you should create a new SQL Database Resource in Presence, with the following settings:-
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:-
You can then use this resource in the SQL node.
| Database Connectivity > Connecting To Access |
