web stats
Mirth Community - View Single Post - How to user the database writer with a MS SQL Server on localhost
View Single Post
  #1  
Old 01-21-2019, 07:15 AM
con con is offline
Mirth Newb
 
Join Date: Nov 2018
Location: Berlin
Posts: 16
con is on a distinguished road
Default 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.
Reply With Quote