Announcement

Collapse
No announcement yet.

How to user the database writer with a MS SQL Server on localhost

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

  • How to user the database writer with a MS SQL Server on localhost

    I have Problems to reach a MS SQL Server 2016 database with the integrated jtds-1.3.1 driver. I have tried all possible URLs and also changed the port.

    Code:
    for example: jdbc:jtds:sqlserver://localhost:port/dbname
    Code:
    for example: jdbc:jtds:sqlserver://localhost:port/dbname;instance=INSTANCE
    and so on. but only get
    Method failed: HTTP/1.1 500 Internal Server Error
    or it is trying to retrieve the tables when I click on "get tables" and nothing happens

    I have changed the login mode to mixed. I can connect with a user to the DB with the Management Studio. Also done the tutorial on the mirth confluence with the same configurations and searched this forum and visited the jtds homepage.

    On another Mirth on a MS Server 2016 I had no problems, using the URL Template from jtds.
    Work for a NPO health care provider in Berlin
    • Current Version of MC 3.4.1.770 with the onboard MySQL Database on a Windows Server 2012 R2

  • #2
    Found the problem

    I think it has something to do with a java display problem. Because I can write and read the database. All I can't do is retrieving the tables with the database writer or reader. I use the 64 Bit version of mirth 3.4.2.8129
    Work for a NPO health care provider in Berlin
    • Current Version of MC 3.4.1.770 with the onboard MySQL Database on a Windows Server 2012 R2

    Comment

    Working...
    X