Cannot find JDBC Driver

[AlexPeake]

I did a standard install of Weka 3-5-6. I added the MS sqljdbc driver (.jar) to the CLASSPATH and I have setup DatabaseUtils.prop

If I start Weka in (with console) mode, I can connect to the database.

If I start it in default mode, I get:

---Registering Weka Editors---
Trying to add JDBC driver: com.microsoft.sqlserver.jdbc.SQLServerDriver - Error, not in CLASSPATH?

in the log, and:

exception: java.sql.SQLException: No suitable driver found for jdbc:sqlserver://localhost;databaseName=MyDatabase

when I try to connect.

Can anyone help? What is sufficiently different in these cases?

Alex

[Mark]

Hi,

Take a look at this post on the Weka mailing list.

https://list.scms.waikato.ac.nz/mailman/htdig/wekalist/2007-October/011554.html

Cheers,
Mark.

[AlexPeake]

Thanks for the pointer.

I have tried modifying the CLASSPATH environment variable (using / and then \\\\), I have tried (in RunWeka.ini) #classpath#, and the literal classpath (using / and then \\\\).

None of them work.

Any other ideas?

Thanks
Alex