Servlet and JDBC error

[Rashmi Trivedi]

Hello All
I am having lot of problem when i am trying to insert date in MS SQL Server database.

On MS SQL Server the column is Change Date and datetime data type.

i get the string variable from HTML form and then convert into java.sql.Date format.

and then insert into SQL Server as setDate.

I am getting following problem:

java.lang.illegalException

java.sql.slqexception - MS SQL Server (ODBC driver error)- Optional features are not installed or implemented.

Please help me out here as i am stuck and do not have much clue as to what to do.

thanks in advance and your help is very much appreciated.

regards,
Rashmi Trivedi

[Jeanne Boyarsky]

Rashmi,
I don't have access to SQL server, but sharing which JDBC driver you are using might help you get an answer.