Edit Transformer Help please

[okken]

Hello All,

I am trying to create a new Transformer by clicking on Edit Transformer and when I do that and click on the "Incoming Data" tab, jsut below there's a box for pasting a sample HL7 message and I can't get that to work. The HL7 file that I am trying to send to the database is in a folder. How do I past this file so that I can do the mapping?

Thanks for your advice.

[pzelenka]

Re:Edit Transformer Help please

Open the example HL7 file in the folder with a text editor and copy the message text to the clipboard. Then paste it into the Incomming Data example window.

[okken]

Re:Edit Transformer Help please

Thanks so much for your help. It worked! I am now getting the following error. It says "No suitable driver found for jdbc:MSSQLServer" I am using SQL Server 2000. Please advice. Thanks.

ERROR-406: JDBC Connector error
ERROR MESSAGE: Error writing to database:
java.sql.SQLException: No suitable driver found for jdbc:MSSQLServer://localhost:1433/DLOHL7
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)

[albertosaez]

Re:Edit Transformer Help please

You need to put the jdbc driver (the jar file with the driver) into the lib/custom dir (and restart mirth)

[nshaik]

Re:Edit Transformer Help please

Installation of the Java Runtime (1.5 or 1.6) and Mirth installation should typically take care of the required environment.

Check if the JDBC connection string is in this format:

jdbc:jtds:«»sqlserver://TestServer:1433/TestDB

TestServer: SQL Server 2000 Server Name

TestDB: Database Name

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

[okken]

Re:Edit Transformer Help please

It worked! Thanks so much! I used the following format:

jdbc:jtds:sqlserver://localhost:1433/DatabaseName

Post edited by: okken, at: 07/06/2007 13:18

[nshaik]

Re:Edit Transformer Help please

Glad it worked! Not sure what happened but the code got cut off.

It should be:

jdbc:jtds:sqlserver://TestServer:1433/TestDB

Post edited by: chrisl, at: 07/08/2007 19:57