Difference between revisions of "Connecting To Access"

From PresenceWiki
Jump to: navigation, search
 
Line 1: Line 1:
== Microsoft Access ==
 
 
 
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