ChemAxon 89bfcec588
11-09-2009 19:02:51
Classification:
UNCLASSIFIED
Caveats: FOUO
I
am evaluating JChem (and all associated programs and modules) and have so far been completely unsuccessful at opening a database in JChem.
The initial dialog box that opens upon running “jcman” requests
locations for the JDBC driver and the URL of the Database to be accessed. I
have tried to follow the instructions on the online “guides” however they state what to put into the
dialog boxes, but do not explain what to do when the recommended values do not
work. I created a blank MS Access database for test purposes to try and get
into the program, to no avail. I tried to link the database using odbc drivers
via SQL server and encountered issues there too. I am not a programmer and have
never worked with java code or SQL Server databases, so a lot of the documents
on the website are Greek to me, for example:
The URL format for the datasource should be, according to the JChem FAQ, “jdbc:odbc:[odbc data source]” however I have been unable to find anything in the JChem documentation on how to create a odbc data source, or how to properly call it in this code.
Is there a walkthrough on how to get started with this program? I feel that just getting the program started shouldn’t be this difficult and I must be missing something.
Any tips would be appreciated.