Announcement

Collapse
No announcement yet.

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?
        Jon Bartels

        Zen is hiring!!!!
        http://consultzen.com/careers/
        Talented healthcare IT professionals wanted. Engineers to sales to management.
        Good benefits, great working environment, genuinely interesting work.

        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