Done everything but Trio sample doesn't work.

[red1984]

I have set up and tested the local, remote and testing sites; set up and tested
the database connection; set everything from my Inetpub directory, wwwroot and
the local site and the database to "full permissions" - and stilll I get the
following list of errors when trying to update the database (insert a record):

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()

Remote and testing server are Local and I copied the trio.mdb from
\samples\database to wwwroot (one troubleshooting tip). No success. Need any
suggestions; everything I've found tells me it should work.

Thank you for any help

R. Richardson
[email]rrichardson@clipper.net[/email]

[Julian Roberts]

It's a permissions issue. See

[url]http://www.charon.co.uk/content.aspx?CategoryID=27&ArticleID=56[/url]

--
Jules
[url]http://www.charon.co.uk/charoncart[/url]
Charon Cart 3
Shopping Cart Extension for Dreamweaver MX/MX 2004

[red1984]

Thank you! After re-reading the article I realized that I had not given theASPNET user full permision. Now I can move on with the rest of the tutorial.

Thanks again

R. Richardson