web stats
Mirth 3.5.1 Azure SQL Server DB connection - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 09-19-2017, 02:02 PM
robAMirth robAMirth is offline
What's HL7?
 
Join Date: Sep 2017
Posts: 5
robAMirth is on a distinguished road
Default Mirth 3.5.1 Azure SQL Server DB connection

Hi all,

I cannot get Mirth to connect to our Azure SQL Server DB.

I have updated the dbdrivers list.

Added sqljdbc42.jar to the custom-libs

Used the connection string from Azure,

But nothing doing. In fact, I dont know what its doing as when I try the "Get Tables" buttin, nothin happens - it just sits there, no error or anything.

Can someone please help me connect Mirth to an Azure DB ?

Thanks
ROb
Reply With Quote
  #2  
Old 09-20-2017, 08:02 AM
BCMirthUser BCMirthUser is offline
OBX.2 Kenobi
 
Join Date: May 2015
Posts: 93
BCMirthUser is on a distinguished road
Default

what does [installationdirectory]/logs/mirth.log say?
Reply With Quote
  #3  
Old 09-20-2017, 08:25 AM
robAMirth robAMirth is offline
What's HL7?
 
Join Date: Sep 2017
Posts: 5
robAMirth is on a distinguished road
Default

ok,

So now I am getting this error.

Could not retrieve database metadata. Please ensure that your driver, URL, username, and password are correct.

com.mirth.connect.donkey.util.xstream.SerializerEx ception: com.thoughtworks.xstream.converters.ConversionExce ption: com.microsoft.sqlserver.jdbc.SQLServerException : com.microsoft.sqlserver.jdbc.SQLServerException
---- Debugging information ----
message : com.microsoft.sqlserver.jdbc.SQLServerException
cause-exception : com.thoughtworks.xstream.mapper.CannotResolveClass Exception
cause-message : com.microsoft.sqlserver.jdbc.SQLServerException
class : java.lang.Exception
required-type : java.lang.Exception
converter-type : com.thoughtworks.xstream.converters.extended.Throw ableConverter
version : not available.......


It looks to be using the right driver from the custom-lib directory but I still have no idea.
Would the connection string be of some use ?

Thanks
Reply With Quote
Reply

Tags
azure, sql server

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:09 PM.


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