HTTP Error Code 405

[Schrawgs]

Hi I am new to web design and just started learning Dreamweaver 8 and have hit a little bump in the road. I have been following a book (Dreamweaver 8 Unleashed) as a teaching tool and have come to the point in the totorial where I need to connect a database to my web page. I'm running on windows vista premium with IIS 7, ASP.NET, and Microsoft Access 2007. I follow all the steps to connect the Access Database but when I try to test the connection string, I get an HTTP Error Code 405 Method Not Allowed. I have tried to use my limited knowledge to try and solve the problem, but am all out of ideas. If anyone could help me solve this problem I would be extremely grateful. It's really frustrating to be stuck like this and not able to move forward.

[Guest]

The latest version of Windows, IIS7 and Access!!!!

Seriously, forget about MSAccess. If you are starting out and learning this stuff go for SQL. It will be worth the extra effort IMHO.

405 errors can be traced to configuration of the Web server and security governing access to the content of the Web site. If you are testing on your local PC I would take a look at the permissions on the directory holding your db. Using IIS. Navigate to the directory and check / set permissions to Read and Write. It may help you, but equally could be a number of things .... sorry :-)

[Schrawgs]

Thanks for the reply. I have to head to class here in a few minutes so I will try the things you mentioned when I get home. Out of curiousity, why do you recommend I switch to SQL over Access?

[Newsgroup_User]

> Thanks for the reply. I have to head to class here in a few minutes so I
> will try the things you mentioned when I get home. Out of curiousity, why
> do you recommend I switch to SQL over Access?


Access will be just fine for you to learn data access. It runs bazillions of
production sites, regardless of how much it is pooh-poohed by the
old-timers. After you get more comfortable with the process, you can
download SQLEXPRESS for your development.

In Internet Explorer, go to Tools - Internet Options - Advanced, and uncheck
"Show friendly error messages" so IE will display the true error message.

Then, in Computer Management - Services and Applications - Internet
Information Server - Web Sites - Default Web Site - IIS - ASP - Compilation,
change "Send Errors To Browser" to TRUE.

Lastly - navigate the file system to
C:\Windows\ServiceProfiles\NetworkService\AppData\Local and give that folder
Change permission for IUSR.

[Schrawgs]

HA! Finally made a successful connection to the database. Thank you so much for the reply, you have no idea how relieved I am now. I'm extremely curious though, how did unchecking friendly error messages, "sending errors to browser" and giving permission to IUSR fix my problem?

[Newsgroup_User]

> HA! Finally made a successful connection to the database. Thank you so
> much
> for the reply, you have no idea how relieved I am now. I'm extremely
> curious
> though, how did unchecking friendly error messages, "sending errors to
> browser"
> and giving permission to IUSR fix my problem?


Your problem was the permissions on the folder. Vista uses that folder as a
temp folder, so if IUSR can't write to it, it won't connect to your
database.

If you have any script errors when you are developing, you have to know what
error so you can troubleshoot. If IIS tells you "An error has occurred",
that won't be very helpful.

[Schrawgs]

ok awesome, thanks for the help