Current location: Hot Scripts Forums » Programming Languages » ASP » getting -2147217900 error while inserting and updating

getting -2147217900 error while inserting and updating

Reply
  #1 (permalink)  
Old 09-18-03, 03:00 PM
skchakri skchakri is offline
Newbie Coder
 
Join Date: Sep 2003
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
getting -2147217900 error while inserting and updating

Hi,
I am getting the following error
-2147217900 Syntax error in INSERT INTO statement
while inserting and "It should be updateable query" error while updating the records of Access DB. I didnt get any problem in the retrievals...I am sure the Queries 100% correct.
I am updating using
ConnObject.execute SQLQuery
__________________
Chakravarthy
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
  #2 (permalink)  
Old 09-20-03, 12:57 AM
Shane Shane is offline
Coding Addict
 
Join Date: Jun 2003
Location: Maryland, US
Posts: 268
Thanks: 0
Thanked 0 Times in 0 Posts
Quote:
Originally Posted by skchakri
Hi,
I am getting the following error
-2147217900 Syntax error in INSERT INTO statement
while inserting and "It should be updateable query" error while updating the records of Access DB. I didnt get any problem in the retrievals...I am sure the Queries 100% correct.
I am updating using
ConnObject.execute SQLQuery
That's a permission problem. Make sure you give the ASP local username write privledges to the database.
__________________
Shane Bauer
Microsoft Certified Professional (MCP) - ASP.NET
ASP/ASP.net, C#, VB/VB.NET, PHP, Perl, SQL
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
  #3 (permalink)  
Old 09-20-03, 06:41 AM
skchakri skchakri is offline
Newbie Coder
 
Join Date: Sep 2003
Posts: 9
Thanks: 0
Thanked 0 Times in 0 Posts
let me know how to set permissions

Hi shane,
Thanx for the reply....
but i didnt get u correctly....
i dont know how to set permissions in ASP land setting privleges to the database.
__________________
Chakravarthy
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
  #4 (permalink)  
Old 09-20-03, 10:34 AM
Shane Shane is offline
Coding Addict
 
Join Date: Jun 2003
Location: Maryland, US
Posts: 268
Thanks: 0
Thanked 0 Times in 0 Posts
Quote:
Originally Posted by skchakri
Hi shane,
Thanx for the reply....
but i didnt get u correctly....
i dont know how to set permissions in ASP land setting privleges to the database.
If you have direct access to the server, just find the access database, right-click on it, and select the "Security" tab. Depending on your version, you may need to click on the permissions button, but you should see a list of usernames. Click on add and add the username "IUSR_XXXXXXX". Replace XXXXX with your machine name. After you add that username, make sure you give that user write privledges.

If you don't have access to the server, ask your host or someone else who has direct access to do it for you.
__________________
Shane Bauer
Microsoft Certified Professional (MCP) - ASP.NET
ASP/ASP.net, C#, VB/VB.NET, PHP, Perl, SQL
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Share on FacebookShare on Stumble UponShare on Twitter
Reply With Quote
Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Forum Jump


All times are GMT -5. The time now is 09:08 AM.
vBulletin® Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.