CodeCharge Studio
search Register Login  

Visual PHP Web Development

Visually Create Internationalized Web Applications, Web Reports, Calendars, and more.
CodeCharge.com

YesSoftware Forums -> CodeCharge Studio -> .NET

 Database problem

Print topic Send  topic

Author Message
Jason T
Posted: 10/24/2004, 1:42 PM

Hey all,

I have been using CCS for about 2 years now but using it only with PHP. I am now trying to migrate over to VB.NET and using CCS as my tutor. However, on my first application, I am having trouble preforming operations on my database. I am using an MSAccess database and the tables use an autoincrement primary key. The application is connecting and reading the database fine but when I try to add or update a record I receive an error saying "Operation must use an updateable query". When I try to delete I receive an error saying "Could not delete from specified tables.". I tried the application in ASP 3.0 and it works fine there, just not VB.NET.

Anyone have an idea of what the problem could be? I would really appreciate the help!!
Jason T
Posted: 10/24/2004, 3:16 PM

I should probably mention that I am using XP and I have read-only unchecked on the database, and IUSR_<my_machines_name> as Full Control, Modify, Read, Read & Execute and Write.
E43509

Posts: 283
Posted: 10/24/2004, 6:03 PM

This is most likely a rights issue.
First look at http://support.yessoftware.com/kb_article.asp?article_id=4
then try to run your app without CCS running. I've found at times CCS puts an exclusive lock on the db
View profile  Send private message
peterr


Posts: 5971
Posted: 10/24/2004, 11:21 PM

When using .NET you may need to set write permissions for the user ASPNET instead of IUSR.
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com
View profile  Send private message
Jason T
Posted: 10/25/2004, 6:35 PM

Peter, yeah, I later realized that. I should have posted what I found but didn't get around to it. Thanks for the help guys!!

Add new topic Subscribe to topic   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

Internet Database

Visually create Web enabled database applications in minutes.
CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.