User 2c6aa21beb
08-06-2010 14:02:47
Hi;
After
installing jchem-5_3_3-windows_with_jre on a 64bit 2008 Windows server,
I’m having
difficulties connecting to the SQlServer database which is on a 32bit machine.
I’m getting
driver not found
Is there
something missing, or not configured for the basic install?
Please find
attached screenshots,
Karl
ChemAxon fa971619eb
08-06-2010 14:06:10
I moved this topic to the JChem forum where it should get answered.
Tim
User 2c6aa21beb
08-06-2010 14:21:01
I got it working by installing the driver sqljdbc_2.0.1803.100_enu.exe
Karl
User 2c6aa21beb
08-06-2010 15:33:42
I'm getting the following error when I try to connect to the web service
<?xml version='1.0' encoding='UTF-8'?><soapenv:Envelope xmlns:soapenv="http://www.w3.org/2003/05/soap-envelope"><soapenv:Body><soapenv:Fault><soapenv:Code><soapenv:Value>soapenv:Receiver</soapenv:Value></soapenv:Code><soapenv:Reason><soapenv:Text xml:lang="en-US">Class Not found : com.microsoft.jdbc.sqlserver.SQLServerDriver</soapenv:Text></soapenv:Reason><soapenv:Detail /></soapenv:Fault></soapenv:Body></soapenv:Envelope>
for the following soap message
<getConnectionAndTableInfo xmlns="http://webservice.jchem.chemaxon"><driver>com.microsoft.jdbc.sqlserver.SQLServerDriver</driver><url>jdbc:sqlserver://********:1433;DatabaseName=dev971;SelectMethod=cursor</url><username>*****</username><password>*****</password><propertyTable>JChemProperties</propertyTable></getConnectionAndTableInfo>
I cant get the WebService to recognise the SQLServer jar file.
Where so I place this sqljdbc4.jar file so that Tomcat finds the jar. I have placed in all the lib directory and a few others without luck.
Any help will be appreciated,
Kind Regards
Karl
Note:
I have noticed that the oracle, mysql and postgres drivers are copied to the work directory, see attached screen shot, how is this done? and how can I add my driver to this list so that it is included in the tomcat work directory
ChemAxon e274e1bada
08-06-2010 16:17:30
Hi Karl,
thank you for the error report, we are investigating
the problem and fix it ASAP. Maybe the bundled driver is not applicable for your server. Could you specify your SQL server version?
Thanks, Edvard
User 2c6aa21beb
08-06-2010 16:28:17
Hi, its SQL Server 2005. The driver works fine for JCMAN because it created the tables perfectly,
Kind Regards
Karl
User 2c6aa21beb
08-06-2010 17:06:31
I removed the jars from the directories and did a system restart and now its finding the driver.
Thanks for your help but it seems to be sorted,