web stats
Error in connecting sql server 2005 - Mirth Community

Go Back   Mirth Community > Mirth Connect > Support

Reply
 
Thread Tools Display Modes
  #1  
Old 08-25-2010, 05:59 PM
sakshi sakshi is offline
Mirth Newb
 
Join Date: Jul 2010
Posts: 6
sakshi is on a distinguished road
Default Error in connecting sql server 2005

I am trying to connect to sql server 2005 and it is giving the exception of "no suitable driver found ".

The url I am using is :-
var dbConn = DatabaseConnectionFactory.createDatabaseConnection ('net.sourceforge.jtds.jdbc.Driver','jdbc:sqlserve r://servernameortnumber/databasename','userid','password');

Is there any thing wrong in the URL or do I have to modify some Mirh files?

Thanks,
Reply With Quote
  #2  
Old 08-27-2010, 07:49 AM
john.newman john.newman is offline
OBX.3 Kenobi
 
Join Date: Oct 2009
Posts: 124
john.newman is on a distinguished road
Default

"no suitable driver found ".

that's strange

correct driver name: net.sourceforge.jtds.jdbc.Driver
what you posted: net.sourceforge.jtds.jdbc.Driver

(same)

so, you've got the class name right. The only other reason that message should happen is if mirth is unable to load the class. The jtds.jar ships with mirth, so check <mirth install dir>\lib\custom\ and verify that you have a jtds-1.2.jar file in there and read permissions are ok.

Other than that, I really dont know what to tell you. If that class is loadable, and you've got the name right, you should be past the no suitable driver found...
Reply With Quote
  #3  
Old 08-31-2010, 01:56 AM
magikbanana magikbanana is offline
OBX.2 Kenobi
 
Join Date: Dec 2007
Posts: 79
magikbanana is an unknown quantity at this point
Default

There is whitespace in "jdbc:sqlserve r:" but maybe this is a typo from copy/paste/anonymization.
Reply With Quote
  #4  
Old 09-02-2010, 09:49 AM
mmkarim mmkarim is offline
Mirth Newb
 
Join Date: Sep 2010
Posts: 8
mmkarim is on a distinguished road
Default

Your connection string, shouldn't it be:

'jdbc:jtds:sqlserver://...'

I think you need to mention the 'jtds' part in your string.
Reply With Quote
  #5  
Old 09-03-2010, 01:17 AM
magikbanana magikbanana is offline
OBX.2 Kenobi
 
Join Date: Dec 2007
Posts: 79
magikbanana is an unknown quantity at this point
Default

For SQL Express I am connecting fine with :
jdbc:jtds:sqlserver://localhost:1443/mirthdb;instance=SQLEXPRESS

For SQL Server :
jdbc:jtds:sqlserver://localhost:1443/mirthdb
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


All times are GMT -8. The time now is 09:35 PM.


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