AbydosGater Posted September 27, 2006 Share Posted September 27, 2006 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: ConnBeneavinMySQL Server: abydosgaters.comUser Name: stargate_testPassword: testingDatabase: stargate_testThese 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 Quote Link to comment Share on other sites More sharing options...
AbydosGater Posted September 27, 2006 Author Share Posted September 27, 2006 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??? Quote Link to comment Share on other sites More sharing options...
wildteen88 Posted September 27, 2006 Share Posted September 27, 2006 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] Quote Link to comment Share on other sites More sharing options...
AbydosGater Posted September 27, 2006 Author Share Posted September 27, 2006 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 Quote Link to comment Share on other sites More sharing options...
AbydosGater Posted October 2, 2006 Author Share Posted October 2, 2006 *BUMP* Quote Link to comment Share on other sites More sharing options...
marcela1637 Posted August 17, 2007 Share Posted August 17, 2007 Exact same problem and no idea how to fix it.GRRRR! Quote Link to comment Share on other sites More sharing options...
moberemk Posted August 18, 2007 Share Posted August 18, 2007 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. Quote Link to comment Share on other sites More sharing options...
marcela1637 Posted August 20, 2007 Share Posted August 20, 2007 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? Quote Link to comment Share on other sites More sharing options...
chronister Posted August 28, 2007 Share Posted August 28, 2007 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 Quote Link to comment Share on other sites More sharing options...
moberemk Posted August 28, 2007 Share Posted August 28, 2007 Try seeing if you can find PHAKT online anymore-that does use ODBC connections. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.