Can't update pages, read/write permissions enabled.

asp, can't, update

[KRMwebdesign]

I've developed an asp website on my server, everything worked fine, happy days, almost finished. Then moved it to my client's server where it is supposed to go live but for some reason I can't insert, update or delete records from the database using the exact same pages as before. I have read/write permissions enabled already so that doesn't seem to be causing the issue.

I wonder can anyone educate me on other possible causes (and solutions) to this problem?

Thanks for any help given.

[LifeinAsia]

Is the database server the same? Does the database server have restrictions on IPs that can access it?

[KRMwebdesign]

I'm using an Ms Access database at the moment but the database server is the same as my ftp server anyways. The database server is on the same IP as FTP. Is that what you mean?

[LifeinAsia]

Is the database data souce setup (and setup correctly) on your client's server?

[KRMwebdesign]

Hi,
Yes the data source is set up correctly. I can display data from the database and I can log into the system using multiple-level authentication.

[LifeinAsia]

The only other things I can think of is that the permissions on the database file(s) itself are not set correctly. What's the OS of the client server?

[KRMwebdesign]

I bet it's something really stupid I forgot to do when moving files or something ;P

I'll keep looking

[LifeinAsia]

If it's a Windows server, make sure the DB file is not set to read only.

And are you getting any error messages?

[KRMwebdesign]

No, there are no errors. When I click submit it goes back to its previous state, almost like it's a static xhtml page but without the info in the form.

[Fotiman]

If you have the option, I would recommend against using Access DB. It does not perform well and over time can grow to enormous size even with very little data in the database, which can further impact performance (speaking from experience). Something like mysql offers much better performance.

Without giving away too much details about your database (no table names or anything), how are you performing the delete/updates? What type of connection are you using, ADO? ODBC? OLEDB? etc.

Also, it could be that you don't have the proper WINDOWS (not IIS) permissions, in which case you might need to contact to host to have them set the proper permissions. Here's a step by step on what needs to be set:
[forums.aspfree.com...]

Hope that helps.

[defanjos]

No, there are no errors. When I click submit it goes back to its previous state, almost like it's a static xhtml page but without the info in the form.

Does the form post to the same page it is on, or to a different page?
If it posts to the same page, make sure "on error move next" is not present on the page ASP code.

If it posts to a different page, does the target page have some kind of redirect to the form page? If so, remove the redirect, and look for errors.

If you get errors, LifeinAsia is probably correct, the database does not have write/modify permissions on.

[KRMwebdesign]

Thanks for the reply Fotiman and defanjos (and LIfeinasia). I worked out the issue. It is because I was working on a preview URL and not a domain name. The form was looking for a domain name to redirect to but wasn't finding it.

Fontiman, yes I understand the issues with MsAccess database but I am just using it for testing purposes. I am going to migrate as soon as the site is working correctly. Thanks for the advice.

Thanks to all.

[defanjos]

Above, I meant "on error resume next" and not "on error move next"