Announcement

Collapse

NextGen (Mirth) Connect 3.9.1 Released!

NextGen (Mirth) Connect 3.9.1 is now available as an appliance update and on our GitHub page. This release contains bug fixes and adds support for eHealth Exchange UDDI providers in the Interoperability plugin. 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

JDBC driver for SQL Server database in Mirt

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

  • JDBC driver for SQL Server database in Mirt

    Anyone who has JDBC driver for SQL Server database for Mirth? PLease help me find an installer..By the way, is it really what I need?
    Tonet

  • #2
    Re:JDBC driver for SQL Server database in Mirt

    Mirth includes a JDBC driver for SQL Server - jtds.

    Google JTDS or search the forums for the connection string.
    Chris Lang

    Comment


    • #3
      Re:JDBC driver for SQL Server database in Mirt

      var dbConn = DatabaseConnectionFactory.createDatabaseConnection (driver, address, username, password);

      Is that what you referring to? BUt where should I put that? Thanks Chris!
      Tonet

      Comment


      • #4
        Re:JDBC driver for SQL Server database in Mirt

        You can use this in ANY transformer, filter or preprocessor. (For the filter and transformer, it needs to be a Javascript step).

        You can also choose a DB reader as a connector on the source. Mirth will read the db for messages - you can specify SQL directly, OR you can use javascript there as well.
        Chris Lang

        Comment


        • #5
          Re:JDBC driver for SQL Server database in Mirt

          I put that code on the filter after declaring the variable contents.
          e.g.
          Code:
          var driver = "net.sourceforge.jtds.jdbc.Driver"; 
          var address = "jdbc:jtds:«»sqlserver://saleslip2k/mirthdb";  
          var username = "sa"; 
          var password = "cardtech";
          is it right? I'll upload screenshots. I hope it's alright

          Post edited by: chrisl, at: 04/25/2007 10:50
          Tonet

          Comment


          • #6
            Re:JDBC driver for SQL Server database in Mirt

            Code:
            var address = "jdbc:jtds:«»sqlserver://saleslip2k:1433/mirthdb";
            Default Port is 1433. Check your server settings (Enterprise Manager / Right-click on server / Properties / General Tab / Network Configuration / TCP/IP / Properties)

            Post edited by: chrisl, at: 04/25/2007 10:51

            Comment

            Working...
            X