Connect Dreamweaver to MySQL hosted by GoDaddy

Hi Experts, this one is over my head and Godaddy is no help at all. But hopefully someone has luck with this before. I have created a MySQL database on godaddy with direct remote connection enabled. I am using dreamweaver cs3 and trying to connedt to that database without luck. I continue to receive an error "HTTP error code 403 Forbidden"

I am new to the mysql stuff so not sure where the problem lies. I
In dreamweaver I have added the correct MySQL server, username, password, database name.

I have searched the web and many have complained about godaddy not helpfull in this matter, but I know it has been done, but I am to new and cannot understand where I am going wrong. Please can some guide me in getting this right?
nkengie81Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

techmazaCommented:
i have not used godaddy for website hosting but i have used other similar web hosting provider like brinkster.com and other i have not faced such problem but i think the problem is with ur syntax or server configuration to allow sql queries to fire....

i think u must provide code written in dreamweaver so that we can figureout the problem
 
0
KechkaCommented:
I think that you won't be able to connect.

selected from link below
HOSTING CAVEAT: The following hosting companies are not DreamWeaver friendly-

    * Godaddy.com hosting - don't even try it. They do not allow a MySQL connection with Dreamweaver

http://www.nebulex.com/index.php?option=com_content&view=article&id=6&Itemid=62

and from adobe newsgroups

I found that DW's PHP/MySQL behaviours are not available using GoDaddy
as a host.

http://www.adobe.com/cfusion/webforums/forum/messageview.cfm?forumid=12&catid=189&threadid=1344073&enterthread=y
0
nkengie81Author Commented:
I have seen that information before, but I also found that it is possible with godaddy, but it was a pain and I don't have the expertize to meake it work.

Techmaza, where in dreamweaver would I find the coding so that I can post here? Remember, I am new to this stuff.
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

nkengie81Author Commented:
This is the script that I am using in my DatabaseConnection.php file. I got this information from Godaddy. I am not sure what goes in the 'your_field' section. Do I need to list all the fields in my database here?
<?php
//Connect To Database
$hostname='jondoe.db.4149523.hostedresource.com';
$username='jondoe';
$password='password1';
$dbname='test';
$usertable='members';
$yourfield = 'your_field';
 
mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
mysql_select_db($dbname);
 
$query = 'SELECT * FROM $usertable';
$result = mysql_query($query);
if($result) {
    while($row = mysql_fetch_array($result)){
        $name = $row['$yourfield'];
        echo 'Name: '.$name;
    }
}
?> 

Open in new window

0
Jason C. LevineNo oneCommented:
What is your testing server set to?  It should exactly mimic the remote server settings...
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
nkengie81Author Commented:
Jason: I am not at my computer right now, but I will take a look at that. That can possibly be my problem. At first I wasn't using a testing server (at least I don't think so). I then download MySQL last night for use as my testing server. You asked "what is my testing server set to" Is there something specific it needs to be. I probally don't understand it all, but learning as I go.

I have install MySQL Query Browser and was able to connect to MYSQL database without problems, so I know it has to be something I am doing wrong in dreamweaver.

Thanks
0
techmazaCommented:
It is correct PHP code to connect to database In PHP to connect with database and fetch the result

       First of all check whether connection is ok i.e, whether 'Unable to connect to database! Please try again later.' error is coming or not if this error is coming then u have to check username, password or hostname and if this message is not coming then check whether database "test" is present or not with table name 'members' and table field  'your_field'  thru phpMyadmin since database is in MySQL.




0
techmazaCommented:
 The problem may be with Testing server what ur Using to test locally if u r testing locally with database residing in ur own server then u have to change connection parameters.

 I suggest to test ur website locally by installing WAMP or LAMP according to ur OS and then u have to just change connection parameters i.e hostname,username and password to connect with godaddy server.

0
nkengie81Author Commented:
I can connect to the test server without problems. I can upload my webpages the remote server. But not the MySQL database. If the test server works ok, is there certain files that I need to transfer to godday for me to connect?
0
Jason C. LevineNo oneCommented:
Did you try what I suggested (set the testing and remote servers to be the same thing)?
0
nkengie81Author Commented:
Thank you guys, I guess I didn't quiet understand the testing server function. I installed the WAMPP, got that running correctly, then made certain that username, database name, server name and password was all the same. Thanks again for pointing me in the right direction. Working on login form, reset, and stuff like that, so sure to back with new questions soon. LOL For those that say that Godaddy won't work, I am living proof that it can.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Adobe Dreamweaver

From novice to tech pro — start learning today.