HL7 Starter Kit – Free Project Tools HL7 Starter Kit

mirth_connect

Connect to MS Access from Mirth March 21, 2017

I installed Mirth Connect today and used the latest java which is Java 8.

Here are the instructions for those who are using Java 7 or previous versions and want to connect to MS Access from Mirth.

https://www.mirthproject.org/community/forums/showthread.php?t=3011

Keep reading if you have Java 8.

https://www.mirthcorp.com/community/issues/browse/MIRTH-3634

Jackcess:

http://jackcess.sourceforge.net/

Place jackcess jar in C:\Program Files (x86)\Mirth Connect\custom-lib

  • Databaser Reader
  • Click “Use Javascript” to YES.
  • Paste the code below in the “javascript” section

var dbConn
try {
dbConn = com.healthmarketscience.jackcess.DatabaseBuilder.open(new java.io.File("c:\\temp\\ASPNetDB.mdb")).getTable("aspnet_Users");
// You may access this result below with $('column_name')
return result;
} finally {
if (dbConn) {
//dbConn.close();
}
}
;

 Mirth channel can be downloaded from my site.

close
mirth_connect

Connect to MS Access from Mirth

Leave a Reply

ViSO Tech

ViSO Tech

Thank you for visiting! Click Facebook icon above and let's connect.
mirth_connect

Connect to MS Access from Mirth March 21, 2017

Search