*
The moose likes JDBC and the fly likes ODBC error: COUNT field incorrect Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "ODBC error: COUNT field incorrect" Watch "ODBC error: COUNT field incorrect" New topic
Author

ODBC error: COUNT field incorrect

Jennifer Sohl
Ranch Hand

Joined: Feb 28, 2001
Posts: 455
Hi. I am using VAJ 3.5 and am trying to update and insert a row into a table. I can run a select statement just fine, but on both the update and insert commands, I keep getting the following error:
A database manager error occurred.
SQL State: 07001
[Microsoft][ODBC SQL Server Driver]COUNT field incorrect
Any ideas? I have a very limited knowledge of SQL, and can't figure out what the heck this is trying to tell me.
Thanks in advance!

Thomas Paul
mister krabs
Ranch Hand

Joined: May 05, 2000
Posts: 13974
Can we see what your insert and update statements look like?


Associate Instructor - Hofstra University
Amazon Top 750 reviewer - Blog - Unresolved References - Book Review Blog
Jennifer Sohl
Ranch Hand

Joined: Feb 28, 2001
Posts: 455
"INSERT INTO dbo.PCVENDX ( PCVNO, PCVNM, PCVA1, PCVA2, PCVCT, PCVST, PCVZ5, PCVCT1, PCVPH1, PCVCT2, PCVPH2, PCVTRM, PCVMIN, PCVCM1, PCVCM2, PCVRTG, PCVFTM, PCVLTL, PCVLTM, PCVSK, PCVPH3, PCVOUT, PCVEML ) VALUES ( :VNUM, :VNAM, :VADDR1, :VADDR2, :VCITY, :VSTAT, :VZIP, :CTC1, :PHN1, :CTC2, :PHN2, :TRMS, :MORD, :COMM1, :COMM2, :TRUCK, :TRTYP, :LTLCAR, :LTLTYP, :SKAP, :FAXN, :OUTC, :VEML )";
"UPDATE dbo.PCVENDX SET PCVNO = :VNUM, PCVNM = :VNAM, PCVA1 = :VADDR1, PCVA2 = :VADDR2, PCVCT = :VCITY, PCVST = :VSTAT, PCVZ5 = :VZIP, PCVCT1 = :CTC1, PCVPH1 = :PHN1, PCVCT2 = :CTC2, PCVPH2 = :PHN2, PCVTRM = :TRMS, PCVMIN = :MORD, PCVCM1 = :COMM1, PCVCM2 = :COMM2, PCVRTG = :TRUCK, PCVFTM = :TRTYP, PCVLTL = :LTLCAR, PCVLTM = :LTLTYP, PCVSK = :SKAP, PCVPH3 = :FAXN, PCVOUT = :OUTC, PCVEML = :VEML WHERE ( ( dbo.PCVENDX.PCVNO = :VNDNO ) )";
Just a note: These statements were generated by the SQL Assist SmartGuide.
Thanks!
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: ODBC error: COUNT field incorrect
 
Similar Threads
ERROR
Reading excel file with data in chinese language using jdbc
exception I got java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver]COUNT field incorrec
Need help with a SQL statement
spring jdbc and action class