Hi Guys,
Hmm this information is not in webMethods documentation so was wondering to share to you folks, the datasource class name should be used to connect to MS SQL Server 2000 with microsoft jdbc driver version 3.0 as 2.x is not available for downloading from MS site.
Datasource Class name : com.microsoft.sqlserver.jdbc.SQLServerDataSource.
Specially if you working on Wm 8.x, JVM 1.6 does not support sqljdbc.jar driver and ask for JDBC driver type 4, so please use sqljdbc4.jar.
Note: Place sqljdbc4.jar in IS/lib/jars direcotry.
cheers!
nD