I appreciate this suggestion. I gave it a try, but am still getting the
same error:
http-80-Processor25/ResourceLimitingJdbcDataSource: Could not return
Connection
java.sql.SQLException: No suitable driver
I also tried cleaning out Tomcat's work folder, but to no avail. I will
now try JTDS as suggested by Laurent Perez.
Lars
On 9/22/2006 1:59 AM, Varga, Zsombor wrote:
hi
We are testing succesfully MS SQL 2005 with microsoft's jdbc driver.
Here is a part of our web.xml, try to add the missing class:
<init-param>
<param-name>load-class</param-name>
<param-value>
com.microsoft.sqlserver.jdbc.SQLServerDriver
com.microsoft.sqlserver.jdbc.SQLServerConnectionPoolDataSource
</param-value>
</init-param>
Zsombor
I tried replacing the three ms jars (mssqlserver.jar, msutil.jar, and
msbase.jar) with sqljdbc.jar, the new sql server 2005 jdbc
driver from ms download site. (This in Cocoon's WEB-INF\lib
folder.) I also adjusted WEB-INF\web.xml to change the driver
class name from
com.microsoft.jdbc.sqlserver.SQLServerDriver
to
com.microsoft.sqlserver.jdbc.SQLServerDriver
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
