Hey guys,
I finally got dreamweaver ASP.Net working on my server (as in it does not give an error when I load a .aspx file that was created in dreamweaver)
Anyway I can display data etc perfectly fine once the files have been uploaded to my online website, however if I try to use the record insertion wizard to create a form that will put data into my access database I get a long error message.
The error message I get is:
System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at DreamweaverCtrls.DataSet.DoInit()
The thing I don’t understand is that if Dreamweaver has generated this code then it should work just fine and there should not be any errors? I have used this method many times to create classic asp pages which work perfectly using the dreamweaver generated code.
Does it just not support .NET very well or have I configured something wrong? I would really rather use asp.NET as opposed to classic asp, but I am working to a tight deadline at the moment.
I want to be able to code the asp.net myself, but for now just need to get it working in time.
