Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rameshkg
Starting Member
22 Posts |
 Posted - 2004-06-18 : 10:52:46
|
| Hi,I am using an UPDATE prepared statement to update a table of SQL Server 2000. I am using parameters in the UPDATE statement and these parameters will be passed with values at runtime. The error i am getting, BEFORE I PASS VALUES TO THE PARAMETERS is as follows :W 5296 (java_extensions.cxx:956): Session.checkConnection(): Microsoft SQLServer error message: [Microsoft][ODBC SQL Server Driver]COUNT field incorrect or syntax errorThe Prepared Statement which i am using is as follows :Update TEMP set X_1 = ?, Y_1 = ?, Z_1 = ?, W_1 = ? where X_1 = ?Any idea as to what is the problem ? Is it because of underscores in column names OR because of '?' as parameter indicators ?I verified the column names, syntax etc., everything is OK.Your early input is appreciated.ThanksRamesh |
|
|
graz
Chief SQLTeam Crack Dealer
4149 Posts |
Posted - 2004-06-18 : 16:46:13
|
| Moderator Note: I moved this out of the Article forum and into this forum.===============================================Creating tomorrow's legacy systems today.One crisis at a time. |
 |
|
|
|
|
|
Error while using the prepared statement