I am trying to find if webMethods 6.5 (32-bit running in a 32-bit Windows 2003 Enterprise Edition) can connect to a SQL Server 2008 (64-bit) database using wMDB Adapter. :uhoh:
I downloaded and installed “Microsoft SQL Server JDBC Driver 3.0” the same way I did previously with 2.0 and 1.1, but it stuffed all DB connections including to SQL Server 2000 and 2005, and this despite Microsoft website saying it is backward compatible.
Your thoughts and advices will be much appreciated.
wM 6.5 itself might be bound to older versions of the SQL Server DB. Eventually there is a Fix for this available from SAG. check the version(s) of DataDirect-Driver located at common/lib/ext/sl53_cjxx.jar.
For the WmDB-Adpater and the WmJDBCAdapter the versions of the SQL Server are less restrictive when using the latest driver from Microsoft download (as pointed out in my last post).
For Java version mentioned above, the sqljdbc4.jar should be working.
Remember to restart the IS after replacing the jar.
At least for the WmDB-Adapter this is definitely required. For the WmJDBCAdapter reloading the package should be sufficient.
From a usability point of view I would prefer WmJDBCAdapter over WmDB-Adapter.