No announcement yet.

Connecting to SQL 2005 Problems

  • 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

    Sql database error 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]

    Hope this helps!


    • #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.