Jump to content


Photo

Dreamweaver: Wount connect to my database!?


  • Please log in to reply
9 replies to this topic

#1 AbydosGater

AbydosGater
  • Members
  • PipPipPip
  • Advanced Member
  • 435 posts
  • LocationAlways at computer!

Posted 27 September 2006 - 02:21 PM

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
www.abydosgaters.com

Current Project: Blog Application.. Undecided name.. Status: Coming along great.

#2 AbydosGater

AbydosGater
  • Members
  • PipPipPip
  • Advanced Member
  • 435 posts
  • LocationAlways at computer!

Posted 27 September 2006 - 02:59 PM

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???
www.abydosgaters.com

Current Project: Blog Application.. Undecided name.. Status: Coming along great.

#3 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 27 September 2006 - 03:06 PM

Looks like your mysql account for the database isnt setup properly. As I failed to connect to your MySQL server with the details provided:
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";


#4 AbydosGater

AbydosGater
  • Members
  • PipPipPip
  • Advanced Member
  • 435 posts
  • LocationAlways at computer!

Posted 27 September 2006 - 03:10 PM

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
www.abydosgaters.com

Current Project: Blog Application.. Undecided name.. Status: Coming along great.

#5 AbydosGater

AbydosGater
  • Members
  • PipPipPip
  • Advanced Member
  • 435 posts
  • LocationAlways at computer!

Posted 02 October 2006 - 06:28 PM

*BUMP*
www.abydosgaters.com

Current Project: Blog Application.. Undecided name.. Status: Coming along great.

#6 marcela1637

marcela1637
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 17 August 2007 - 03:24 AM

Exact same problem and no idea how to fix it.
GRRRR!

#7 moberemk

moberemk
  • Members
  • PipPipPip
  • Advanced Member
  • 695 posts

Posted 18 August 2007 - 04:07 AM

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.
Disclaimer: No matter how harsh I may be, I'm always IMO only.

#8 marcela1637

marcela1637
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 20 August 2007 - 04:54 PM

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? 

#9 chronister

chronister
  • Members
  • PipPipPip
  • Advanced Member
  • 1,438 posts

Posted 28 August 2007 - 05:06 AM

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
"If you give someone a program, you will frustrate them for a day; if you teach them how to program, you will frustrate them for a lifetime."

If at first you don't succeed, try again. Then quit. There's no use being a damn fool about it.
-- W.C. Fields

#10 moberemk

moberemk
  • Members
  • PipPipPip
  • Advanced Member
  • 695 posts

Posted 28 August 2007 - 12:52 PM

Try seeing if you can find PHAKT online anymore-that does use ODBC connections.
Disclaimer: No matter how harsh I may be, I'm always IMO only.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users