File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
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 Make it so: Java DB Connections & Transactions this week in the JDBC 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: 32844

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!