Jump to content

Archived

This topic is now archived and is closed to further replies.

AbydosGater

Dreamweaver: Wount connect to my database!?

Recommended Posts

HI, Ive been trying to do this for months, well i gave up awhile back but now im determined to get this to work for my new project!
Ive been trying to get dreamweaver MX to connect to my database on my remote host/server with the following info!

So i click on myslq connection and the box appears ok..

Connection Name:    ConnBeneavin
MySQL Server:        abydosgaters.com
User Name:             stargate_test
Password:               testing
Database:               stargate_test

These are real details, i set up a stargate_test account+database with that password for you people with dreamweaver MX already working with databases to test it if you wish!
Oh and also with cPanel i have added an access host of %. This should mean that all of you can access my server! (I hope).

But when i do this from my computer all i get is a popup message : "An Unidentified error has occured"
It is really important that i get this to work!
Any help is greatly appriciated!

Andy

Share this post


Link to post
Share on other sites
Ehh just so you know i think its connecting to the host cause it says hot found please wait and then shows the error :P dam thing. anyone know whats going on??? or more importantly how to fix it???

Share this post


Link to post
Share on other sites
Looks like your mysql account for the database isnt setup properly. As I failed to connect to your MySQL server with the details provided:
[code=php:0]echo "Connecting to MySQL...<br /><br />";

mysql_connect('abydosgaters.com', 'stargate_test', 'testing') or die(mysql_error());

echo "connected to MySQL server<br /><br />";

echo "Selecting database...<br /><br />";

mysql_select_db('stargate_test') or die(mysql_error());

echo "Selected database";[/code]

Share this post


Link to post
Share on other sites
ehh well i dont know then??
what should i do? it is set up right! ehh should the host be abydosgaters.com?
or the ip address of my host? but still it doesnt work from within dreamweaver?

andy

Share this post


Link to post
Share on other sites
Generally what this means is that the database you're trying to access is blocked off from people logging on from off the server-you'll have to set up a local test server to work with the database, as your host isn't letting you access it directly.

Share this post


Link to post
Share on other sites
I thought this might be a problem but I can connect to the hosting server's (Webhost Freaks) mySQL via an ODBC connection on my computer- I create my database in Access and export it to mySQL.  If it were the server disallowing a remote connection (like GoDaddy does) wouldn't this include ODBC connections? 

Share this post


Link to post
Share on other sites
I could be wrong, but I don't believe that DW will use an ODBC connection. I think it just tries to use the HTTP protocol.

But as I said, I could be wrong.

Nate

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.