What does this mean???

[kayoca]

What does this message mean?

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

I am using this SQL statement.

INSERT INTO MailingList (Email) VALUES ('[email protected]');

Can someone maybe explain this message??

[monte96]

You need to post more code than that.. but I would say your trying to use that SQL statement in a recordset. Just use the connection object's execute method to execute the insert.

[kayoca]

Am sorry, I am using the Execute command for executing the SQL statement. But my problem is, its working fine
on my local computer. But when i want to execute it on the server its giving me this error. Its running on Windows 2000 Server.

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

But here is my execute code

// Javascript
var oConnection;
var sConnectionString = 'Provider=Microsoft.Jet.OLEDB.4.0; 
    Data Source=C:\Inetpub\wwwroot\wwwvbdungeonnet\database\dungeon.mdb';

oConnection = Server.CreateObject( 'ADODB.Connection' );

try {
  // open the database, catching any errors that occur
  oConnection.Open( sConnectionString );
} catch ( e ) {
  // display error message
  DatabaseException ( e );
}

if ( oConnection )
  oConnection.Execute( 'INSERT INSERT INTO MailingList (Email) VALUES (\'[email protected]\');' );

[monte96]

Other than the word Insert twice in the SQL statement (Which I'm assuming was just a typo), I don't see anything wrong.. although I must admit I've never used Javascript to do that before.. (Come to think of it why ARE you using Javascript? The code is running on the server side..)

[Sundance Kid]

Pay me and I will give your answer

I had the SAME problem. Is you database read only ? Right click and make SURE it is not read only. And if that doesn't work... check your permissions on the server.

But my $$ is on that your database is set to read only!

(Well mine was when I also got the same error.... what a day that was)

P.s
oConnection.Execute( 'INSERT INSERT INTO MailingList (Email) VALUES (\'[email protected]\');' );

I'm not sure about the \'[email protected]\ the ('\') if it will work in SQL like that.

Without the '\' it should work fine your SQL.

[JoshT]

The '\' is gotta be an escape character for the single quotes...

First time I've seen someone use JScript for ASP, although it supposedly is faster than VBScript.

[kayoca]

Originally posted by JoshT

First time I've seen someone use JScript for ASP, although it supposedly is faster than VBScript.

It's not that hard to use JavaScript in ASP. JavaScript is more Object Oriented then VBScript.

But i have found out why this error is displayed at my screen. The guest account didnt have any rights to my database.