JDBC configuration

User aac02bdca0

13-01-2006 00:02:52

We're using Marvin 4.03. We're trying to access SQL server 2000. We've filled in the attached information into "Connecting to a Database" prompt and we received a java.lang.ClassNotFoundException error for com.microsoft.jdbc.sqlserver.SQLServerDriver. We've installed the driver. Any idea where we went wrong?

ChemAxon 9c0afc9aaf

13-01-2006 12:00:41

Hi,





You just have to include the appropriate JDBC driver in your CLASSPATH environment variable.


In the case of SQL Server the driver consists of 3 files:


- msbase.jar


- mssqlserver.jar


- msutil.jar





Each of these (with absolute path) should be listed in your CLASSPATH.





Best regards,





Szilard

ChemAxon 9c0afc9aaf

13-01-2006 12:06:38

PS: Please see the following page on how to set environmental variables and on other JChem installation tasks:





http://www.chemaxon.com/jchem/doc/admin/prepscripts.html





Szilard