Forums
This topic is locked
sql db connection without testing server
Posted 16 Sep 2003 19:52:57
1
has voted
16 Sep 2003 19:52:57 louis walch posted:
i do not have a testing server, so i set the testing server prefs to be the same as my ftp settings (like in a technote i found on macromedia.com) when i try to connect to my sql server to test the connection i get this error:http error 404
1) there is no testing server running on the server machine
2) the testing server specified for this site does not map to the www.mydomain.com/_mmServerScrtips/MMHTTPDB.php.URL
do i HAVE to have a testing server running in order to simply use the sql db connection tools?
Edited by - ldw on 16 Sep 2003 20:15:44
Replies
Replied 17 Sep 2003 17:13:45
17 Sep 2003 17:13:45 Julio Taylor replied:
Hi
I'm assuming you're running IIS / Apache / PWS on your machine to run a local webserver. To run dynamic applications you need to be running a webserver of some type.
If so, make sure that ALL URL references point to your local webserver location (e.g. localhost/foldername). I've found this problem before, and it's grossly under-documented.
I hope that helps. Let me know if you need more help.
------------------------
Julio
PHP | MySQL | DWMX
ICQ: 19735247
MSN:
I'm assuming you're running IIS / Apache / PWS on your machine to run a local webserver. To run dynamic applications you need to be running a webserver of some type.
If so, make sure that ALL URL references point to your local webserver location (e.g. localhost/foldername). I've found this problem before, and it's grossly under-documented.
I hope that helps. Let me know if you need more help.
------------------------
Julio
PHP | MySQL | DWMX
ICQ: 19735247
MSN:
Replied 19 Sep 2003 16:05:13
19 Sep 2003 16:05:13 Moazam Baig replied:
Hi!
I have understood your problem and I know it is very frustrating as well. I had the same problem once but I was able to resolve it.
Yes, I think you need to be able to setup a testing server on your remote host (that is if your webserver is on the ISP or the hosting company's server) to be able to connect to the database through Dreamweaver. Other wise you can hard code the connection string ( DSN Less) etc. Don't worry it will not get that complicated.
You get this error because the dreamweaver is unable to locate the root folder for your website on the remote webserver.
First, you should remove the www from the URL prefix. You should have some thing like this
yourdomain.com/
Second thing is check your host directory. Do not give your FTP settings in that. Try some thing like this
Host directory: www/ (this is usually for IIS) For apache it could be rootWWW or something.
Best thing is to ask your hosting company. They should be able to explain.
I wrote this assuming you were trying to connect to a remote host. If you have a localhost then do what poolio has mentioned. Hope this helps.
I have understood your problem and I know it is very frustrating as well. I had the same problem once but I was able to resolve it.
Yes, I think you need to be able to setup a testing server on your remote host (that is if your webserver is on the ISP or the hosting company's server) to be able to connect to the database through Dreamweaver. Other wise you can hard code the connection string ( DSN Less) etc. Don't worry it will not get that complicated.
You get this error because the dreamweaver is unable to locate the root folder for your website on the remote webserver.
First, you should remove the www from the URL prefix. You should have some thing like this
yourdomain.com/
Second thing is check your host directory. Do not give your FTP settings in that. Try some thing like this
Host directory: www/ (this is usually for IIS) For apache it could be rootWWW or something.
Best thing is to ask your hosting company. They should be able to explain.
I wrote this assuming you were trying to connect to a remote host. If you have a localhost then do what poolio has mentioned. Hope this helps.