Pinned topicWAS220.127.116.11 with MSSQL 2008 Type 3 driver Sqljdbc4.jar
This question has been answered.
This question has not been answered yet.
Currently we are migrating MSSQL 2000 database to MSSQL2008 in our testing phase in WAS7 we change the driver file to Sqljdbc4.jar but when test the connection from admin console still we can see older version of jar file 2/11/13 16:53:09:506 EST 00005abb DSConfigurati I DSRA8205I: JDBC driver name : Microsoft SQL Server 2005 JDBC Driver 2/11/13 16:53:09:514 EST 00005abb DSConfigurati I DSRA8206I: JDBC driver version : 1.2.2828.100 2/11/13 16:53:09:523 EST 00005abb DSConfigurati I DSRA8025I: Successfully connected to DataSource
following steps completed still old version info in log file
1.Copy new Sqljdbc4.jar file
2.Define Websphere variables on cluster scope
3.Create JDBC provider Microsoft SQL Server JDBC Driver and datasource
Any input will be appreciate
Take a look at the JDBC Datasource item in WAS or the deployment manager. That should show you the WAS variables used in the path to the driver. You can trace it down by looking at WAS Variables and find out what is actually defined for those var1ables. Can you confirm that you have truly put the jar exactly whe th JDBC DS is configured to look and that the jar name is the one with the 4 in it?
Probably, you tried all that, but... just in case.