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

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 01-21-2019, 07:15 AM
con con is offline
OBX.1 Kenobi
 
Join Date: Nov 2018
Location: Berlin
Posts: 33
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
  #2  
Old 01-22-2019, 11:38 PM
con con is offline
OBX.1 Kenobi
 
Join Date: Nov 2018
Location: Berlin
Posts: 33
con is on a distinguished road
Default 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
Reply With Quote
Reply

Tags
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 04:29 PM.


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