Skip to main content
Inspiring
March 22, 2007
Answered

Dreamweaver won't connect to database

Hi all, I really need help with this, I've contacted my hosting companies support and they think that there isn't a problem server-side.
By the way I've done the same thing in the past with no problems whatsoever.

I keep getting this error when trying to create a new connection to my database: : "Your php server doesn't have the MySQL module loaded or you can't use the mysql_(p)connect functions."

The hosting compant has disabled mysql_pconnect(). I know about this, because a different app stopped working when the hosting company disabled this without telling anyone. Dreamweaver automatically uses pconnect, but all i've done before is removed the 'p' and everything has worked.

Now if I do this, I try to create a new recordset, and choose the connection, then I get '***No table found' in the table dropdown. This happens with allmy old connections that did work.

Because of this, I can't do anything now at all with my database! I just wondered if anyone had this problem before, or if anyone had any suggestions at all! cheers

dave

PS sorry about the stupid screen name, anyone know how i can change that?
This topic is closed to new replies. Start a new post to keep the conversation going.
Newsgroup_UserCorrect answer
Inspiring
April 1, 2007
Powderskier9@gmail wrote:
> - This is a long and winded explanation, but I believe that each of the steps
> are necessary to confirm that you have the prerequisite functionality and files
> for this setup(Apache 2.24, PHP 5.21, MySQL 5.0.37) to work on a Windows PC.

Yes, it is a long-winded explanation, and you deserve credit for you
perseverance. However, it's quite clear that you missed out a vital step
when using the PHP 5.2.1 Windows installer, when you are prompted to
choose which extensions to install. If you had selected the correct
extensions at that stage, everything should have been up and running in
about five minutes.

I have detailed instructions on my website for using the Windows installer:

http://foundationphp.com/tutorials/php_installer.php

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

12 replies

Inspiring
March 22, 2007
jnkjnkjnkjnkjn wrote:

> Hi all, I really need help with this, I've contacted my hosting companies
> support and they think that there isn't a problem server-side.
> By the way I've done the same thing in the past with no problems whatsoever.
>
> I keep getting this error when trying to create a new connection to my
> database: : "Your php server doesn't have the MySQL module loaded or you can't
> use the mysql_(p)connect functions."
>
> The hosting compant has disabled mysql_pconnect(). I know about this, because
> a different app stopped working when the hosting company disabled this without
> telling anyone. Dreamweaver automatically uses pconnect, but all i've done
> before is removed the 'p' and everything has worked.
>
> Now if I do this, I try to create a new recordset, and choose the connection,
> then I get '***No table found' in the table dropdown. This happens with allmy
> old connections that did work.
>
> Because of this, I can't do anything now at all with my database! I just
> wondered if anyone had this problem before, or if anyone had any suggestions at
> all! cheers
>
Try deleting your connection script(s):
Site >> Advanced >> Remove Connection Scripts

Then recreating them(it)
http://livedocs.adobe.com/dreamweaver/8/using/wwhelp/wwhimpl/common/html/wwhelp.htm?context=LiveDocs_Parts&file=28_con19.htm

Mick
Translate