web stats
How to user the database writer with a MS SQL Server on localhost - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Thread Tools Display Modes
Prev Previous Post   Next Post Next
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.

for example: jdbc:jtds:sqlserver://localhost:port/dbname
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

database, database reader, djbc, jtds, mssql

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

All times are GMT -8. The time now is 05:11 AM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Mirth Corporation