[ART.118.5042] Adapter Runtime (Connection): Unable to enable connection resource
[ART.118.5063] Adapter Runtime (Connection): Unable to start connection after 1 attempt(s).
[ADA.1.205] Cannot retrieve the metadata. "
(HY000/195) [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]‘SCHEMA_NAME’ is not a recognized function name."
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]‘SCHEMA_NAME’ is not a recognized function name.
Receiving the above error on the webMethods IS 8.2.2.0 ( IS_8.2_SP2_Core_Fix20). Could someone help?
You may have to check the JDBC adapter fix level currently installed. I assume few fixes applied will work only on the supported version of MSQL servers. Kindly review the system requirements guide and fix-read me.
please make sure that you use a recent version of the MSSQL JDBC Driver (latest version is 4.2 as version 6 is still in preview state). It can be obtained from MSDN for free without registration.
You should consider to apply JDBC_6.5_Fix53 as well as WAR_8.2_SP2_Fix7 (ART).