Config MWS with SQL Server 2005

When I was configuring MWS I got two problems:

  • The configurator couldn’t recognize a named SQL server instance, such as server\dev1; The configurator complained that the server is not running at all or login failure.I created an alias using cliconfg to get around this problem;

  • When connecting to a SQL 2005 server, it complained that “Data type 0x38 is unknown”. I did some search, it looks like the configurator is using a 2000 JDBC driver to connect to the 2005 server.

I think webMethods is using the Merant driver sl53_cj34.jar as default.

I am wondering if anyone experienced the same issue and fixed it eventually.


MWS 7.0 does, and it works with IS 6.5.