wM 10.3 adapter needs to be changed from sybase to MS SQL db

Hi Istkhar,

My apologies, I’ve given the instruction the other way around, I thought you’re moving from SQL Server to Sybase.

In that case, you’ll have to find the relevant MS SQL Server JDBC driver for the SQL Server you’re using.

Place at the same folder under WmJDBCAdapter, then use the following class name for datasource name.

Microsoft SQL Server DataSource for JDBC driver
For NO_TRANSACTION and
LOCAL_TRANSACTION:
com.microsoft.sqlserver.jdbc.SQLServerDataSource
For XA_TRANSACTION:
com.microsoft.sqlserver.jdbc.SQLServerXADataSource

You might want to use check if Sybase ASE to SQL Server Migration - SQLines Tools able to help you to migrate the database objects over without needing to rewrite them in SQL Server side. But that’s beyond what webMethods can assist you, and most of the time the responsibility of the implementor/consultant to sort out.