Check my SQL
Proublem with my code, works on my IIS does not work with my hosting company.
19) strSQL = "INSERT INTO Book (Name, Age, Email, Gender, Comments) VALUES ('" + nm + "','" + ag + "','" + em + "','" + gen +"','" + com + "');";
20) rset = adoCon.Execute(strSQL);Its in JScript ASP. This is the error i get.
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/angel/agb.asp, line 20
s0da posted this at 18:10 — 16th March 2004.
He has: 157 posts
Joined: Mar 2004
i dont know much bout asp but i know how to google
the only thing i can tell you is prolly try and debug. write out the syntax on the page and see if everything is koshur.
Links:
http://www.webthang.co.uk/tuts/tuts_asp/gk_errors/gk_errors.asp#9
http://help2.hostway.com/documents/winplatform/online/Ch0612.html
forwardtrends posted this at 18:32 — 16th March 2004.
He has: 52 posts
Joined: Feb 2003
email is a reserved name in SQL .. try enclosing it in [email]
bja888 (not verified) posted this at 19:09 — 16th March 2004.
They have: 5,633 posts
Joined: Jan 1970
Dident help
forwardtrends posted this at 19:38 — 16th March 2004.
He has: 52 posts
Joined: Feb 2003
Then you need to get read / write permission on the directory holding your .mdb file. Most likely will have to contact your host.
Busy posted this at 20:56 — 16th March 2004.
He has: 6,151 posts
Joined: May 2001
I don't do ASP either, my guess would be the end of line 19 ;); one do da ';' to many
bja888 (not verified) posted this at 15:21 — 18th March 2004.
They have: 5,633 posts
Joined: Jan 1970
Im pritty sure you need a ';' at the end of a SQL string and you need a ';' at the end of a javascript command. I dont think its a permission proublem bacause the error was refering to the SQL
Chroder posted this at 15:40 — 18th March 2004.
He has: 91 posts
Joined: Mar 2004
I think Busy means ; ); into );. I don't think SQL needs a semicolon at the end.
Greg K posted this at 16:22 — 18th March 2004.
He has: 2,145 posts
Joined: Nov 2003
I did a search for the error you are having, and here are some of the results that offered solutions. Most of the pages I came across indicate a permissions problem.
http://support.microsoft.com/default.aspx?scid=kb;en-us;q175168
http://www.loadboy.com/help/faq-1.aspx
http://support.codecharge.com/kb_article.asp?printable=1&kb_articlesPage=6&article_id=72
http://www.learnasp.com/learn/FAQdbUpdate.asp
-Greg
bja888 (not verified) posted this at 21:30 — 19th March 2004.
They have: 5,633 posts
Joined: Jan 1970
OK ill look into the permissions, as for the ';', it works on ym server so there is no reason that that should have any effect on the other server.
dhotchin posted this at 19:25 — 22nd March 2004.
He has: 183 posts
Joined: Nov 2003
Are you using ACCESS? if you are sum server only work in access 97! NOT 2000. Just another thing 2 look in 2. It normaly mean that the datbase is not there or wrong permissions.... i think
Want to join the discussion? Create an account or log in if you already have one. Joining is fast, free and painless! We’ll even whisk you back here when you’ve finished.