Connect to SQL via Dreamweaver

I keep getting errors

[casey133]

i tried to set up dreamweaver to connect to a MySQL database on my web server and i keep getting this error:

HTTP error code 404 file not found. here are some possible reasons

1. there is no testing server running on the server machine

2. the testing server specified for this site does not map to the [ftp.mysite.net...] URL. Verify that the URL prefix maps to the root of the site.

i contacted my hosting company and they say that their servers do not support remost access to SQL databases, is this true? cause i have never heard of anyone not support remote access.

[zollerwagner]

Just a couple of thoughts.

First, is there a space or underline in front of the directory "mmServerScripts"? Is the file name exactly the same as what you have on the server, including capitals? I know that's pretty basic, but it bites us all often enough.

Second, although it's not clear to me what it is you want to do, I don't think you can access mySQL databases directly.

I've always interacted with mySQL with php scripts or through myPHPAdmin. MyPHPAdmin is a browser-based mySQL administration utility that you'd probably access through the control panel of your web host.
Hope something in that helps. It looks like you've tried running a php script, so you may know this.

Third, you're using ftp? Is that to upload the script or to run it? I've never tried running a script by ftp. Sounds like a no-go to me, but I might be wrong.

Plus, you've got both http: and ftp. in that statement. That strikes me as likely to be unworkable.

[casey133]

thanks for the fast reply, what i was more or less doing was creating a testing server and was just trying to connect to an already created sql database using DW... i will give your ideas a try and see how it works out, thanks again