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

Error connecting sql server

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

  • Error connecting sql server

    While connecting to MS SQL Server 2000 , I am receiving follwoing error:

    ERROR 2008-05-13 15:49:36,231 [8f0293cc-ef62-4609-bf2b-686dcf892a4d_source_conne
    ctor._jdbcEndpoint#466435734.receiver.1] com.webreach.mirth.connectors.jdbc.Jdbc
    MessageReceiver: org.mozilla.javascript.WrappedException: Wrapped java.sql.SQLEx
    ception: No suitable driver found for jdbc:sqlserver://KASHI/RADREPORTTEXTSEARCH
    ; (2865cf7b-1ba1-401d-8b70-1aa8683d0312#2)

    my conection string is

    var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('net.sourceforge.jtds.jdbc.Driver','jdbc:sqlserve r://KASHI/RADREPORTTEXTSEARCH;','RADTXTSRCH','radtxtsrch');
    var result = dbConn.executeCachedQuery("Select * from RADREPORTTEXTSEARCH where REPORTDATE= '1/1/2008' ");

    I am new to MIRTH, please help.

    regards.

  • #2
    Re:Error connecting sql server

    your connection string should look like this: jdbc:jtds:sqlserver://SERVERNAME:1433/DATABASENAME;
    Reid Hospital and Healthcare

    Comment


    • #3
      Re:Error connecting sql server

      Thanks , yes now i am connected to SQL database. Even without specifying the port. Which is good in my case as my hospital runs Database on different server and they keep changing Ports for security reason.

      Now I am working to figure out how to create transformer as the end result is not good. Actually my task is to read Database and write HTML files with well formated Heading and links.

      Kashif

      Comment

      Working...
      X