close ad
Install the LAtest Updates to Work with CC 2017 and CC 2018
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

MySQL Connection - HTTP Error Code 405 Method Not Allowed?

Thread began 1/08/2014 4:55 am by Nathon Jones Web Design | Last modified 2/04/2014 1:27 pm by Jason Byrnes | 4522 views | 19 replies |

Nathon Jones Web Design

MySQL Connection - HTTP Error Code 405 Method Not Allowed?

Nyerg...trying to plunge myself into PHP and MySQL but have hit a hurdle right from the off in that I can't seem to connect to my hosted MySQL database via Dreamweaver.

When trying to create a MySQL Connection I receive the error:
HTTP Error Code 405 Method Not Allowed

I've been all over Google looking for a solution but can't find one. Would some kind soul here please help me out with this?
Thank you.
NJ

Sign in to reply to this post

Jason ByrnesWebAssist

double check the site settings for the testing server.

since you are trying to connect to the remote MySQL servert, the testing server settings should use FTP to connect to your remote server.

make sure that the web URL you add is a valid URL.

In some cases, the ftp connection may connect to the server below the web root. You may need to add a Host directory like /public_html to force the ftp conection to point to the same location as the web URL.

when making a database connection, the testing server you define for the site is used. Most connection issues are a result of not properly setting the testing server.

Sign in to reply to this post

Nathon Jones Web Design

local vs ftp

I had set the testing server to Local/Network but, obviously, I don't have MySQL installed locally. D'oh!
I assume, in order for me to be able to test my sites offline, like I do with my Classic ASP websites, I need to install PHP locally? MySQL?
Even with my Classic ASP websites though, I didn't need to have MSSQL server installed locally as I could just connect direct to that data source which I always found really useful.

Once I changed the testing server to FTP, and entered the FTP details, it all worked.

Thank you Jason.
Regards
NJ

Sign in to reply to this post

Jason ByrnesWebAssist

yes, to test locally you need a testing server, see the following tutorials:
http://www.webassist.com/tutorials/Set-up-a-test-server-on-Mac-OS

http://www.webassist.com/tutorials/Set-up-a-test-server-on-Windows

Sign in to reply to this post

Nathon Jones Web Design

database?

Will I need to recreate our hosted MySQL database locally or will it pick up on the hosted database as long as I have the test server installed?
Thanks Jason.

Regards
NJ

Sign in to reply to this post

Jason ByrnesWebAssist

You will need to recreate it locally

Sign in to reply to this post

Nathon Jones Web Design

out of sync?

So, in testing, if changes are made to the database then I'd have to replicate those changes in our hosted database as a seperate action? Harumpff! :(

That's a real nuisance because we will have to recreate umpteen tables and views simply for testing purposes when we already have them created in our hosted database. Is there any quick fix to that?

I'm quite happy always connecting to the hosted database however in the Dreamweaver Bindings tab we can't expand our recordsets to check fields, change field formats. It's a real pain!

For example, before (classic asp / mssql) we would simply select a field from our recordset and Dreamweaver would allow us choose a format for it from a list.

I only discovered this because I was trying to display an INT field as currency:
<?php echo $row_rsPRODS['LEDprice']; ?>

So, digging around on Google we tried this...
<?php echo money_format($row_rsPRODS['LEDprice']); ?>

...but that just produces errors. It's frustrating because I know Dreamweaver has simple ways of doing this but because we can't use our live database, whilst working locally, we can't access these tools.

It seems odd to me that you'd need to create two data sources just to create one database driven website. Surely what ends up happening is that the two become out of sync, no?

Appreciate the help and advice, as ever. Thank you.
Regards
NJ

Sign in to reply to this post

Jason ByrnesWebAssist

if you set your site definition top use the remote server as the testing server, it can connect to the remote database.

if you use a local testing server, then you will have 2 databases.

for development purposes, the data in the database shouldn't matter, you shouldn't need to have the exact same data in your local database to develop your pages, but if you do, then use the remote server as both the remote and testing server.

Sign in to reply to this post

Nathon Jones Web Design

If I use the remote server then I can't expand my recordsets in the Bindings panel. When I try to, I get the following error:

DataSources
An unidentified error has occured.

What's frustrating is that in the Databases panel I can view the list of tables in my remote MySQL database, and expand these to view the table fields...so why can't I open a recordset in the Bindings panel?

This is preventing me from using Dreamweaver to help me learn PHP. I would find it really helpful if I could use Dreamweaver exactly as I used to with classic asp because the translation between the two would be so much more logical, in my mind, because my familiarity is with the Dreamweaver tools.

Am I misunderstanding something in the testing and remove server department? (apart from a brain!)

Thank you.
NJ

Sign in to reply to this post

Jason ByrnesWebAssist

that means the settings are not correct.

make sure to have the correct URL Prefix for the site added, and also edit the connection to use the remote details.


you may need to set a Host Directory if the FTP connection connects bellow the site root.

Sign in to reply to this post
loading

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now.  Build a store, a gallery, or a web-based email solution.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...