problem with datasource configuration

[ebrmp]

I'm trying SQL SERVER2000 using Microsoft JDBC driver with JBoss 2.2.2.
Always I try to deploy a CMP entity bean using SQL SERVER I get my server.log file the message "Unable to create PreparedStatement". If I change my datasource configuration connection driver/url to use jdbc-odbc bridge, all works fine.

[gramesh]

Hi,

Current MSSQL driver for jdbc needs to set SelectMethod as "cursor" in ConnectionURL , if not set the default is "direct".May be you did not specify anything for SelectMethod in your configuratin file (mssql-service.xml), check the attached config file for ConnectionURL specification.