Announcement

Collapse

Mirth Connect 3.12.0 Released!

Mirth Connect 3.12.0 is now available as an appliance update and on our GitHub page. This release includes database performance improvements, improves visual HL7 representation, message pruning, keystore handling, PDF generation, community contributions, and fixes several security vulnerabilities. This release also contains many improvements to commercial extensions. 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

Connecting to SQL 2005 Problems

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

  • Connecting to SQL 2005 Problems

    I've been trying for a while to connect MIRTH to the SQL 2005 on my machine/localhost. I have tried everything, but I get no connection whatsoever.

    For one, which Driver do I choose? PostgreSQL? or SQL Server/Sybase?

    Two, I have no idea what to put in the URL. I've tried http://localhost:1433 (I'm assuming 1433 is the default MS SQL port????)

    Can someone please tell me how I can do this? I keep getting errors. What I need to do is take a few elements from an HL7 message, and insert it to the Database. I'm testing this on my local machine first, before attempting to do as a solution. Any help would be greatly appreciated.

    Thank you....

    Oh and I'm attaching the xml file. Name of the Database is TESTDB, and the table is Pyxis. Pyxis_LLP_In.xml (29798 bytes)

    Post edited by: aht75, at: 10/28/2008 12:07

  • #2
    Re:Connecting to SQL 2005 Problems

    Refer forum posts:

    SQL Server 2000/2005 connection string
    http://www.mirthproject.org/index.ph...0&catid=2#7390


    Sql database error
    http://www.mirthproject.org/index.ph... catid=2#4593

    Also, in the Microsoft KB article below, refer to the section, "1. Determine the TCP/IP port number of the instance of SQL Server."

    [b]How to connect to a named instance of SQL Server 2005 or SQL Server 2000 by using the client tools in the earlier version of SQL Server[b]
    http://support.microsoft.com/kb/265808

    Hope this helps!

    Comment


    • #3
      Re:Connecting to SQL 2005 Problems

      Thank you much, that worked. What I used was:

      SQL Server/Sybase as the Driver
      I used "jdbc:jtds:sqlserver://localhost:1433/"Database Name"" for the URL

      And used the Username and Password to the DB, and I was able to write successfully.

      Comment

      Working...
      X