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

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.

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

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

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

You will need to recreate it locally

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

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.

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

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.