JDBC driver for SQL Server database in Mirt

[shifting_18]

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?

[chrisl]

Re:JDBC driver for SQL Server database in Mirt

Mirth includes a JDBC driver for SQL Server - jtds.

Google JTDS or search the forums for the connection string.

[shifting_18]

Re:JDBC driver for SQL Server database in Mirt

var dbConn = DatabaseConnectionFactory.createDatabaseConnection (driver, address, username, password);

Is that what you referring to? BUt where should I put that? Thanks Chris!

[chrisl]

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.

[shifting_18]

Re:JDBC driver for SQL Server database in Mirt

I put that code on the filter after declaring the variable contents.
e.g.

var driver = "net.sourceforge.jtds.jdbc.Driver"; 
var address = "jdbc:jtds:«»sqlserver://saleslip2k/mirthdb";  
var username = "sa"; 
var password = "cardtech";

is it right? I'll upload screenshots. I hope it's alright

Post edited by: chrisl, at: 04/25/2007 10:50

[nshaik]

Re:JDBC driver for SQL Server database in Mirt

var address = "jdbc:jtds:«»sqlserver://saleslip2k:1433/mirthdb";

Default Port is 1433. Check your server settings (Enterprise Manager / Right-click on server / Properties / General Tab / Network Configuration / TCP/IP / Properties)

Post edited by: chrisl, at: 04/25/2007 10:51