PDA

View Full Version : Data Entry


jeffreystolet
02-08-2005, 10:19 PM
Hi there,

I'm having a hard time entering new records to MSSQL Server and Access databases. Dreamweaver seems to have it all: a simple insert record behavior.

However, I keep getting the following error messages:

[1] ACCESS

"
System.Data.OleDb.OleDbException: Operation must use an updateable query.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr)
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS 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 DreamweaverCtrls.DataSet.DoInit()
"

[2] MSSQLSERVER 2000

"
System.Data.SqlClient.SqlException: Line 1: Incorrect syntax near '-'.
Line 1: Incorrect syntax near '-'.
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at DreamweaverCtrls.DataSet.DoInit()
"

Someone said that it had to do with the location of the database. Where am I supposed to put it?

Could anyone help me out here, please? Thanks.

steinp
04-17-2005, 10:24 AM
Hi, I have the exact same problem (with Access database). Have you solved the problem yet?

Anyone else have any suggestions?

Thanks!