web stats
JDBC driver for SQL Server database in Mirt - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 04-24-2007, 01:03 AM
shifting_18 shifting_18 is offline
OBX.3 Kenobi
 
Join Date: Apr 2007
Posts: 143
shifting_18
Default JDBC driver for SQL Server database in Mirt

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?
__________________
Tonet
Reply With Quote
  #2  
Old 04-24-2007, 08:45 AM
chrisl chrisl is offline
Mirth Employee
 
Join Date: Aug 2006
Posts: 967
chrisl is an unknown quantity at this point
Default 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.
__________________
Chris Lang
Reply With Quote
  #3  
Old 04-24-2007, 10:11 PM
shifting_18 shifting_18 is offline
OBX.3 Kenobi
 
Join Date: Apr 2007
Posts: 143
shifting_18
Default 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!
__________________
Tonet
Reply With Quote
  #4  
Old 04-24-2007, 11:27 PM
chrisl chrisl is offline
Mirth Employee
 
Join Date: Aug 2006
Posts: 967
chrisl is an unknown quantity at this point
Default 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
Reply With Quote
  #5  
Old 04-25-2007, 01:25 AM
shifting_18 shifting_18 is offline
OBX.3 Kenobi
 
Join Date: Apr 2007
Posts: 143
shifting_18
Default 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";
is it right? I'll upload screenshots. I hope it's alright

Post edited by: chrisl, at: 04/25/2007 10:50
__________________
Tonet
Reply With Quote
  #6  
Old 04-25-2007, 03:15 AM
nshaik nshaik is offline
Mirth Guru
 
Join Date: Sep 2006
Posts: 302
nshaik
Default Re:JDBC driver for SQL Server database in Mirt

Code:
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
Reply With Quote
Reply

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
No suitable driver Error - SQL Server 2005 RHavlick Support 1 02-03-2009 06:59 PM
Advantage Database Driver and PrepareStatement peisima Support 3 09-03-2008 04:18 AM
Stopped Database reader chnl - No Suitable Driver rseay Support 0 09-28-2007 11:35 AM
AS400 JDBC Driver jglucky Support 1 03-30-2007 09:33 AM
Missing mysql jdbc driver? fleetwoodfc Support 2 09-19-2006 09:07 PM


All times are GMT -8. The time now is 12:26 PM.


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