Dreamweaver - 500 Internal Server Error

http://forums.iis.net/p/1153439/1886232.aspx

Which point you to this:

http://faq.matchware.com/en/?q=90

This error message will appear when trying to manipulate a file-based Access
database whose data files are write protected. An example of this is while
running the "Database" Mediator 9-example on Windows Vista.

The solution is to relax the security settings of either the datafile
itself, or the folder containing the files. The following guide will tell
you how to set the security settings for the Database example to their
lowest level on Windows Vista:


Browse to the folder (default location is C:\Program
Files\Matchware\Mediator 9\Examples )

Rightclick the "Database" folder and choose Properties

Click the Security tab

Click the Edit button, and answer "Continue" when prompted for
Administrative rights

Click Add...

Type "Everyone" (without the quotes) into the name field, and click OK

Select "Everyone" from the user list, and check "Full control" in the
Permissions list.

Click OK to close the Security window, then OK again to close the property
page.

It's important to notice that this will enable ALL users on the computer to
modify the folder, so be careful which folders you enable these settings
for. After this is done, your queries should work immediately.

And here is the MS answer:

http://support.microsoft.com/default.aspx/kb/175168

--
Ken Ford
Adobe Community Expert - Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Adobe Certified Expert - ColdFusion 8
Fordwebs, LLC
http://www.fordwebs.com
http://www.cfnoob.com


"mtrueblood" <webforumsuser@macromedia.com> wrote in message
news:gh7b16$jgt$1@forums.macromedia.com...
>I actually decided to read the blog, and I have solved that issue...
>
> Here is the error I get when I try to submit my contact us ASP page:
>
> Microsoft OLE DB Provider for ODBC Drivers error '80004005'
>
> [Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable
> query.
>
> /NewSite/registration.asp, line 141
>
> Thanks - Matt
>
>

I actually decided to read the blog, and I have solved that issue...

Here is the error I get when I try to submit my contact us ASP page:

Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.

/NewSite/registration.asp, line 141

Thanks - Matt

Yes, I get the HTTP 500 Internal Server Error. Just the general server error message as I have Show Friendly HTTP Error Message turned on. When I choose to not Show Friendly HTTP Error Messages, I get this:

--An error occurred on the server when processing the URL. Please contact the system administrator.
If you are the system administrator please click here* to find out more about this error.--

here* takes me to - http://blogs.iis.net/thomad/archive/2007/02/06/security-is-painful.aspx

I don't know why that happens. I don't see how an error message on a URL I type in, can send me to someones blog, but that's another issue I can figure out later. Now I just want to focus on accessing the MS Access database from the contact us ASP page.


Thanks for your help! - Matt

Matt,

No that would not cause your problem.

Are you getting any errors when you try?

--
Ken Ford
Adobe Community Expert - Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Adobe Certified Expert - ColdFusion 8
Fordwebs, LLC
http://www.fordwebs.com
http://www.cfnoob.com


"mtrueblood" <webforumsuser@macromedia.com> wrote in message
news:gh798g$hfa$1@forums.macromedia.com...
> Great tutorials! Thank you for the information.
>
> I have my pages created already and based on your tutorials, I think I
> have
> all of them created correctly. One difference is that I have created a
> Data
> Source Name (DSN) to where you created a Customer Connection String...
> Could
> that be the difference? Could that be the answer as to why my contact us
> page
> cannot modify the MS Access database when the form is submitted?
>
> I seem to think that I have to change the permissions on the MS Access
> database that will allow the contact us ASP page to make modifications to
> the
> database... Do you think I am off base in thinking so?
>
> Thanks - Matt
>

Great tutorials! Thank you for the information.

I have my pages created already and based on your tutorials, I think I have all of them created correctly. One difference is that I have created a Data Source Name (DSN) to where you created a Customer Connection String... Could that be the difference? Could that be the answer as to why my contact us page cannot modify the MS Access database when the form is submitted?

I seem to think that I have to change the permissions on the MS Access database that will allow the contact us ASP page to make modifications to the database... Do you think I am off base in thinking so?

Thanks - Matt

These were for Dreamweaver MX, but might still be useful:

http://www.fordwebs.com/mx-asp/index.asp

--
Ken Ford
Adobe Community Expert - Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Adobe Certified Expert - ColdFusion 8
Fordwebs, LLC
http://www.fordwebs.com
http://www.cfnoob.com


"mtrueblood" <webforumsuser@macromedia.com> wrote in message
news:gh76ou$ej1$1@forums.macromedia.com...
>I actually got it to work finally!
>
> One last problem I am having is that I cannot send data (a new record) to
> my
> MS Access database file via form, from my contact us ASP page. But I can
> add a
> record to my database manually, save it, upload it, and view the
> contactus_results page to see the new record is there.
>
> What do I need to do to allow access from the contact us ASP page to the
> MS
> Access database.
>
> Please help! Thanks - Matt
>

I actually got it to work finally!

One last problem I am having is that I cannot send data (a new record) to my MS Access database file via form, from my contact us ASP page. But I can add a record to my database manually, save it, upload it, and view the contactus_results page to see the new record is there.

What do I need to do to allow access from the contact us ASP page to the MS Access database.

Please help! Thanks - Matt

You need to turn off friendly HTTP error messages in Internet explorer to
see what error you are getting.

To do this in IE, click Tools > Internet Options > Advanced > and uncheck
the Show friendly HTTP error messages checkbox.

Now view your page and let me know what the error is.

--
Ken Ford
Adobe Community Expert - Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Adobe Certified Expert - ColdFusion 8
Fordwebs, LLC
http://www.fordwebs.com
http://www.cfnoob.com


"mtrueblood" <webforumsuser@macromedia.com> wrote in message
news:gh3sof$83p$1@forums.macromedia.com...
>I found an adobe tutorial that walks a user through setting up an ASP
> development environment and Developing a web application with Dreamweaver.
> Here
> is the issue:
>
> I can access the send.asp page with server behaviors, no problem, but I
> can
> access the View.asp page by typing http://localhost/MyWebApp/view.asp in
> the
> URL, only if I have removed the Bindings. Send.asp works fine, view.asp
> does
> not. No Bindings and the page will load either through Live Data View,
> Preview
> in Browser, and by typing http://localhost/MyWebApp/view.asp in the URL.
> Once I
> add the Bindings back to the page, the page will not load and I get the
> HTTP
> 500 Interal Server Error everytime.
>
> The Connection to Database test feature reported a successful connection
> to
> the database. IIS is running smoothly as my timetest.asp file works
> everytime.
> Please help!
>

The tutorial is here if needed:

http://www.adobe.com/devnet/dreamweaver/articles/setting_up_asp_02.html#configs

Thanks - Matt

I found an adobe tutorial that walks a user through setting up an ASP development environment and Developing a web application with Dreamweaver. Here is the issue:

I can access the send.asp page with server behaviors, no problem, but I can access the View.asp page by typing http://localhost/MyWebApp/view.asp in the URL, only if I have removed the Bindings. Send.asp works fine, view.asp does not. No Bindings and the page will load either through Live Data View, Preview in Browser, and by typing http://localhost/MyWebApp/view.asp in the URL. Once I add the Bindings back to the page, the page will not load and I get the HTTP 500 Interal Server Error everytime.

The Connection to Database test feature reported a successful connection to the database. IIS is running smoothly as my timetest.asp file works everytime. Please help!