my dog learned polymorphism
The moose likes JDBC and Relational Databases 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 OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Servlet and JDBC error" Watch "Servlet and JDBC error" New topic

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.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.

Rashmi Trivedi
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 32635

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

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: Servlet and JDBC error
It's not a secret anymore!