Anyone who has JDBC driver for SQL Server database for Mirth? PLease help me find an installer..By the way, is it really what I need?
Announcement
Collapse
No announcement yet.
JDBC driver for SQL Server database in Mirt
Collapse
X
-
Re:JDBC driver for SQL Server database in Mirt
You can use this in ANY transformer, filter or preprocessor. (For the filter and transformer, it needs to be a Javascript step).
You can also choose a DB reader as a connector on the source. Mirth will read the db for messages - you can specify SQL directly, OR you can use javascript there as well.Chris Lang
Comment
-
Re:JDBC driver for SQL Server database in Mirt
I put that code on the filter after declaring the variable contents.
e.g.
Code:var driver = "net.sourceforge.jtds.jdbc.Driver"; var address = "jdbc:jtds:«»sqlserver://saleslip2k/mirthdb"; var username = "sa"; var password = "cardtech";
Post edited by: chrisl, at: 04/25/2007 10:50Tonet
Comment
-
Re:JDBC driver for SQL Server database in Mirt
Code:var address = "jdbc:jtds:«»sqlserver://saleslip2k:1433/mirthdb";
Post edited by: chrisl, at: 04/25/2007 10:51
Comment
Comment