I have a legacy application running on SQL Server 2000. webMethods platform recently upgrades from 8.2.2 to 9.7. The issue I have is to configure 9.7 IS talks to SQL Server 2000. The JDBC connection works well in 8.2.2, however when enabling it in 9.7, I got the following error. All settings are same in 8.2.2 and 9.7. Both environments are using JDBC Adapter 6.5 and sharing same SQL Server driver. I take a look at the 9.7 System Requirements. 9.7 does not support SQL Server 2000. Is there a way to make this work? There is no way to upgrade the legacy application to new version as it’s going to be decommissioned.
Here is the error message.
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
[ADA.1.205] Cannot retrieve the metadata. "
(S00010/195) ‘SCHEMA_NAME’ is not a recognized function name."
‘SCHEMA_NAME’ is not a recognized function name.