Difference between revisions of "Connecting To Access"
Line 1: | Line 1: | ||
− | |||
− | |||
When connectiong to Access you can use the ODBC drivers | When connectiong to Access you can use the ODBC drivers | ||
Revision as of 19:29, 2 January 2010
When connectiong to Access you can use the ODBC drivers
First create an odbc connection from Administrative Tools - Data Sources (ODBC)
http://www.international-presence.com/images/docs/jdbc/odbcdetails.png
http://www.international-presence.com/images/docs/jdbc/odbclist.png
After this create an SQL 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