We have configued to connect MSSQL DB which is on windows machine from our BI application which is running on AS400 box using UD connect.
We have completed all the steps but when we do the connection test using http://<server>:<port>/TestJDBC_Web/TestJDBCPage.jsp we are facing Class driver not found error.
Caused by: com.sap.ip.bi.sdk.exception.BIResourceException: Class DriverName is not found
... 22 more
Caused by: java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver
Found in negative cache
I have few doubts here, after we configured the jdbc type 4 driver in visual admin, we could see sqljdbc.jar(driver file) being copied to two locations - 1. \usr\sap\<SID>\DVEBMGSXX\j2ee\cluster\server0\temp\dbpool
The file t location is hs size equl to original driver file but the file at location 2 is of size zero.
I want to get clarified wht is the significance of these two locations and if we have to set CLASSPATH on as400 server which patch from the above needs to be considered.
COuld you kindly help us in resolving this isse
Edited by: Poloju on Aug 19, 2010 1:02 PM