Difference between revisions of "Connecting To Access"
Line 2: | Line 2: | ||
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 you mdb file. | ||
http://www.international-presence.com/images/docs/jdbc/odbcdetails.png | http://www.international-presence.com/images/docs/jdbc/odbcdetails.png | ||
+ | |||
+ | After this you will see your newly created connection in the list of DSNs | ||
http://www.international-presence.com/images/docs/jdbc/odbclist.png | http://www.international-presence.com/images/docs/jdbc/odbclist.png | ||
− | + | 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 | http://www.international-presence.com/images/docs/jdbc/accessdetails.png | ||
Note, the driver class is sun.jdbc.odbc.JdbcOdbcDriver | Note, the driver class is sun.jdbc.odbc.JdbcOdbcDriver | ||
+ | |||
and the connection url is jdbc:odbc:yourdsn | and the connection url is jdbc:odbc:yourdsn | ||
Revision as of 19:33, 2 January 2010
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 you mdb file.
http://www.international-presence.com/images/docs/jdbc/odbcdetails.png
After this you will see your newly created connection in the list of DSNs
http://www.international-presence.com/images/docs/jdbc/odbclist.png
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
Note, the driver class is sun.jdbc.odbc.JdbcOdbcDriver
and the connection url is jdbc:odbc:yourdsn
Hit test, to check the connection:-
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