Announcement

Collapse

NextGen Connect 3.10.1 Released!

NextGen (Mirth) Connect 3.10.1 is now available as an appliance update and on our GitHub page. This release contains bug fixes. See the release notes for the list of fixes.

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

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

Edit Transformer Help please

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

  • Edit Transformer Help please

    Hello All,

    I am trying to create a new Transformer by clicking on Edit Transformer and when I do that and click on the "Incoming Data" tab, jsut below there's a box for pasting a sample HL7 message and I can't get that to work. The HL7 file that I am trying to send to the database is in a folder. How do I past this file so that I can do the mapping?

    Thanks for your advice.

  • #2
    Re:Edit Transformer Help please

    Open the example HL7 file in the folder with a text editor and copy the message text to the clipboard. Then paste it into the Incomming Data example window.

    Comment


    • #3
      Re:Edit Transformer Help please

      Thanks so much for your help. It worked! I am now getting the following error. It says "No suitable driver found for jdbc:MSSQLServer" I am using SQL Server 2000. Please advice. Thanks.

      ERROR-406: JDBC Connector error
      ERROR MESSAGE: Error writing to database:
      java.sql.SQLException: No suitable driver found for jdbc:MSSQLServer://localhost:1433/DLOHL7
      at java.sql.DriverManager.getConnection(Unknown Source)
      at java.sql.DriverManager.getConnection(Unknown Source)

      Comment


      • #4
        Re:Edit Transformer Help please

        You need to put the jdbc driver (the jar file with the driver) into the lib/custom dir (and restart mirth)

        Comment


        • #5
          Re:Edit Transformer Help please

          Installation of the Java Runtime (1.5 or 1.6) and Mirth installation should typically take care of the required environment.

          Check if the JDBC connection string is in this format:

          Code:
          jdbc:jtds:«»sqlserver://TestServer:1433/TestDB
          TestServer: SQL Server 2000 Server Name

          TestDB: Database Name

          Default Port is 1433 (Enterprise Manager / Right-click on server / Properties / General Tab / Network Configuration / TCP/IP / Properties)

          Comment


          • #6
            Re:Edit Transformer Help please

            It worked! Thanks so much! I used the following format:

            jdbc:jtds:sqlserver://localhost:1433/DatabaseName

            Post edited by: okken, at: 07/06/2007 13:18

            Comment


            • #7
              Re:Edit Transformer Help please

              Glad it worked! Not sure what happened but the code got cut off.

              It should be:

              jdbc:jtds:sqlserver://TestServer:1433/TestDB
              Post edited by: chrisl, at: 07/08/2007 19:57

              Comment

              Working...
              X