By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,571 Members | 994 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,571 IT Pros & Developers. It's quick & easy.

OleDB Exception

P: n/a
I am using ASP.NET with an Access database.

When I issue a ExecuteNonQuery operation, it fails. So I print out the
sql statment, and the exception info.. Here it is..

I am unable to find the "syntax" error. When I cut and paste the query
into Access it runs fine..

Can anyone spot the problem?

---- START --------

UPDATE eventURLs SET webcast = '', quesmang = '', metrics = '',
preregistration = '', survey = '', password = '', archiveWebcast = '',
archiveSurvey = '', archiveMetrics = '', chairESN = '', chairExternal =
'', participantESN = '', publicNumber = '', technicalESN = '',
technicalExternal = '', technicalPasscode = '', audioConfEmail = '',
otherDetails = '' WHERE eventID = 10

Syntax error in UPDATE statement.

System.Data.OleDb.OleDbException: Syntax error in UPDATE statement. at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr)
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPA
RAMS dbParams, Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior
behavior, Object& executeResult) at
System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method) at
System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at
Eventsdb.editEventDetails.EventURLsSubmit_Click(Ob ject sender, EventArgs
e) in
D:\Profiles\BNAICK\VSWebCache\mmsurveys.ca.nortel. com\Eventsdb\Admin\edi
tEventDetails.aspx.vb:line 897

---- END -----
*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 18 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.