smithproject.org

Hello,

This is a Windows XP system. Here's what I've done.

1.) Dowloaded and extracted mysql-connector-java-5.0.8.zip
(also tried mysql-connector-java-5.1.7.zip)

2. Placed mysql-connector-java-5.0.8-bin.jar in: C:\smith-bin-windows-1.3b6\wwwroot\WEB-INF\lib

(also tried C:\smith-bin-windows-1.3b6\lib)
(also tried mysql-connector-java-5.1.7-bin.jar in both locations)

3.) Have tried setting CLASSPATH in System Control Panel to whatever appropriate path was being used.

4.)After each attempt, restarted SMITH.

5.) Datasource is setup as follows:

jdbc url: jdbc:mysql://localhost/ccc_vote

(have also put port :3306 after localhost)

jdbc driver full class name: com.mysql.jdbc.Driver

(MySQL db is at C:\smith-bin-windows-1.3b6\wwwroot\data\ccc_vote)

In every case, datasource will not validate. I get the red X. Clicking on it gives me:

Error Message:
com/mysql/jdbc/Driver

Any ideas what I'm missing?

Thanks!

Does anyone have any more detail on connecting to an MS Access datasource? Orcus mentions the " corresponding JDBC driver" but I don't see what that would be for Access/ODBC. Any specific examples would be MUCH appreciated.

I've looked at both threads on the topic in this Forum but still can't seem to get it to work i.e. get the datasource setup properly.