Difference between revisions of "Connecting To Access"

Revision as of 10:29, 14 July 2010

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.

Revision as of 19:38, 2 January 2010 (view source) Graham (Talk \| contribs) ← Previous diff		Revision as of 10:29, 14 July 2010 (view source) Admin (Talk \| contribs) Next diff →
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