Thursday, May 22, 2014

confusion with the sqlserver driver classname

sqlserver 2005 jdbc driver:sqljdbc.jar
driver class name : com.microsoft.sqlserver.jdbc.SQLServerDriver
sqlserver 2000 jdbc driver:msbase.jar,mssqlserver.jar,msutil.jar
driver class name : com.microsoft.jdbc.sqlserver.SQLServerDriver
Often people get confused with the driver class name and the driver to be used.The best approach I follow is to open the jar[say sqljdbc.jar] with a winzip[or equivalent] and observe the path.

No comments:

Post a Comment

Featured Post

Generate single index on table 

Transaction tables such as F0911, F4111 etc hold a huge amount of data probably a third of petabyte. Generating indexes on such tables (th...

Popular Posts