Mirth Community

Mirth Community (http://www.mirthcorp.com/community/forums/index.php)
-   Support (http://www.mirthcorp.com/community/forums/forumdisplay.php?f=6)
-   -   How to user the database writer with a MS SQL Server on localhost (http://www.mirthcorp.com/community/forums/showthread.php?t=218890)

con 01-21-2019 07:15 AM

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.

con 01-22-2019 11:38 PM

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


All times are GMT -8. The time now is 06:44 AM.

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