This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC and the fly likes database connectivity using java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "database connectivity using java" Watch "database connectivity using java" New topic

database connectivity using java

bala kan
Ranch Hand

Joined: Aug 20, 2012
Posts: 44

Hi good morning to everyone,

i have done java program using jdbc odbc driver to update the table "table1" in database "update"..

the codes are as

when we execute this file, it gives an error like that

unable to connect
error is java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrect..

i have been using ms-access 2007 database, please let me know why this program doesn't work..

Thanks in advance
Vishal Shaw
Ranch Hand

Joined: Aug 09, 2012
Posts: 179
Check out your query

It requires only three columns , but you are trying to put 4 inputs

Programming is about thinking, NOT coding
bala kan
Ranch Hand

Joined: Aug 20, 2012
Posts: 44
thank you very much vishal
It is sorta covered in the JavaRanch Style Guide.
subject: database connectivity using java
Similar Threads
Help with "unable to connect to database" problem
Can't delete a row in an Access database
problem in inserting data into ms access
Problem in inserting Date feild
jframe not accepting sql query..