Ticket Options

Question Details

TICKET ARCHIVE -> Setting Up Dreamweaver Mx 2004 to Work With Mysql Database Remotely

dcmiltown - Jul 1, 2005 - 4:59 pm

I have set up Dreamweaver MX 2004 locally with PHP and mySQL and have designed a site that works properly.

I am running OS X Tiger 10.4 on a Mac Dual G5... using Safari as my browser.

I have been trying to get this site to work remotely through my webhost.

The website is located at http://www.myspacewhore.com/.

PHP is version 4.3.3 (http://www.myspacewhore.com/date.php) is the PHP info page.

I have set up a manually typed PHP page that just grabs all the entries from my news database... there is only one entry, but that works correctly (http://www.myspacewhore.com/test.php).

My main problem is that I cannot setup Dreamweaver MX 2004 to connect to my database. I believe I have everything set up correctly... but there are some variables that I have read different ways to do it online.

I am thinking it has something to do with the location or functionality of the connection scripts on the server. If I go to the server at (http://www.myspacewhore.com/_mmServe...s\MMHTTPDB.php) according to dreamweaver help (http://www.macromedia.com/cfusion/kn...fm?id=tn_16515) I should get:

Notice: Undefined index: Type in c:\inetpub\wwwroot\mysite\_mmServerScripts\MMHTTPDB.php on line 13

Notice: Undefined variable: oConn in c:\inetpub\wwwroot\mysite\_mmServerScripts\MMHTTPDB.php on line 20

but I just get a 500 Internal Server error.

I have tried going to files/advanced/remove connection scripts, and reuploading them... still does not work.

I basically get the undefined error when trying to setup the connection. I have tried changing my URL prefix from http://www.myspacewhore.com/ to http://www.myspacewhore.com/mainwebsite_html.

I am running out of ideas... any help would be greatly appreciated.

My host is badandyhosting.com.

I have double checked all passwords for the database... the database name, etc. I have used myspacewhore.com for the mysql server, i have also used localhost... and my host's address.

Thank you!

dl33 - Jul 2, 2005 - 6:08 pm

Hi,

try this and tell me what the results were: (After that I will try to help you further)

Create an test.php file on your server.
Clear all code in the file
Copy the following code into the file:

mysql_connect("localhost","YOUR USER NAME","YOUR PASSWORD") or die ( "connection failed" );
mysql_select_db("YOUR DATABASE NAME") or die ( "database selection failed" );
?>

substitute the text in capitals with your own data

Try this and tell me what you saw when you visited the page with a normal web browser.

Hope this helped,
dl33

dcmiltown - Jul 2, 2005 - 6:19 pm

Thank you for your suggestion. Somehow I fixed it... however I am not sure exactly how. I downgraded to Dreamweaver MX, using the same files and uploaded the site, and tried to connect to the database using all the same settings. It worked... and I then went back to Dreamweaver MX 2004, same settings... and connected... and it worked again. Really confused but relieved. I think it may have been something with the connection string files but I don't know for sure.

Thanks again!

DAN