Announcement

Collapse

Mirth Connect 4.1.1 Released!

Mirth Connect 4.1.1 is now available as an appliance update and on our GitHub page. This release contains modifications to the Welcome to Mirth Connect screen and two fixed defects. See the release notes for the list of fixes and updates.

Download | See What's New | Upgrade Guide | Release Notes

For discussion on this release, see this thread.
See more
See less

Microsoft Access question

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Microsoft Access question

    Does mirth support reading from an MS Access database?

    If so, how do you connect?

    Thanks!

  • #2
    Re:Microsoft Access question

    I have successfully connected to a MS Access database in the past using Mirth. To do this, set the driver to "Sun JDBC-ODBC Bridge" and use the following connection string:
    Code:
    "jdbc:odbc:«»DBNAME"
    However, I have run into some problems with the JDBC-ODBC bridge driver included with Mirth. We cannot control the behavior of this driver and we cannot include proprietary drivers in the release, so I recommend using a commercial driver for this if you run into problems using it.

    Post edited by: chrisl, at: 09/04/2007 12:02
    Brendan Haverlock | Mirth Software Engineer | Mirth Corporation

    Comment


    • #3
      Re:Microsoft Access question

      Wonder if any updated information on successful connections to MS Access databases...

      thanks very much !!!

      Comment


      • #4
        Re:Microsoft Access question

        The JDBC OBDC bridge that brendanh suggested is still the only way to get at it.

        Does that work for you or did you run into trouble?

        Comment


        • #5
          Re:Microsoft Access question

          Thanks ! Just exploring possible use with MS Access at this point -not testing or implementing. Already have many points already using Access, so to avoid trouble perhaps workaround via MySQL - or commercial driver route. Thanks again!

          Comment

          Working...
          X