Sorry all,
Before mentioning the problem,the connection was lost.I am extremely sorry for that.
I have developed a portal for a Quiz application.I am using JSP as front end and MS SQL Server as backend.
I am encrypting both the question and correct answer.While I am trying to store these details into the database I am getting a SQL exception.
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Incorrect syntax near '_vm'.
I fixed the issue.The reason for the problem is,While encrypting the text it will insert the ' & " .While trying to insert that into DB,the SQL server is trigerring this exception.
The data type of the field in the database is varchar2(1000).
Please help me to resolve this.