I am attempting to connect to a database for a legacy system that runs SQL Server 6.5 using the JDBC adapter and having some troubles. The error message that I am receiving is not that helpful either:
[ART.118.5036] Adapter Runtime (Connection): Unable to configure connection manager.
I am using the datasource class “net.sourceforge.jtds.jdbcx.TdsDataSource”. I’ve tried both versions 0.6 and 0.7.1 of the jTDS JDBC driver and receive the same error for both.
I’ve had no issues in the past connecting to a SQL 2000 database using the JDBC driver provided by microsoft, however, I also can’t connect to a 2000 database with the jTDS driver.
Has anyone been able to connect to a SQL 6.5 database? Has anyone been able to successfully use the above mentioned JDBC driver within webMethods?
Any help/comments would be greatly appreciated.