aspose file tools*
The moose likes JDBC and the fly likes Servlet and JDBC error Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of The Java EE 7 Tutorial Volume 1 or Volume 2 this week in the Java EE forum
or jQuery UI in Action in the JavaScript forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Servlet and JDBC error" Watch "Servlet and JDBC error" New topic
Author

Servlet and JDBC error

Rashmi Trivedi
Ranch Hand

Joined: Aug 13, 2001
Posts: 60
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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30352
    
150

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


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Servlet and JDBC error