Jump to content

Dreamweaver MySQL Connection


Recommended Posts

yeah i got the same problem that you have. But Once i made mysql connections succesfull. That happen when I remove IIS then reinstall it.But its not always succes.I guess the file that dreamweaver created is the source of the problem. Sometimes after the unidentified error message occured the another error message occurs.It says the file is being used by another program but i dont know which program use that file. any one have solutions ? :unsure:

Link to comment
Share on other sites

  • 1 month later...

Same problem happened to me. I followed Dreamweaver's help file on installing PHP and MySql, and the "Unidentified Error" thingie showed on connection.

 

I found this solution:

1) When I installed php, I downloaded the "Windows Installer" package. That actually didn't come with support for MySQL (oh, this took some time to figure allright ...)

2) What I needed was the files php_mysql.dll and libmysql.dll.

3) I downloaded the full php package, and copied out the dll files to \winnt\system32.

4) Uncomment the line extension=php_mysql.dll in php.ini.

5) Voilá, the test connection worked.

 

HTH,

haavarl

Link to comment
Share on other sites

  • 3 weeks later...

I have a similar problem with Dreamweaver, I downloaded PHP 5.0.2.2 and MySQL Server 4.1. They have been installed in a Windows Server 2003.

 

When i tried to connect from another computer in the local network to PHP, it works normally, it gave some troubles with ASP pages, but nothing to became crazy, it just change my MS Access databases permission. Well, now i can connect to PHP, but it wont let me connect to MySQL database. I can connect MySQl from ASP pages with MyODBC without problems, but my boss want to migrate his web page to PHP, any suggests???

 

Please, i have lost many brain cell with this!!!!!!!!! :blink:

Link to comment
Share on other sites

  • 1 month later...
  • 4 weeks later...

SUMMARIZING 4 TROUBLESHOOTING POINTS FOR MYSQL CONNECTION

 

1) In Dreamweaver, go to Sites/Manage Sites/Advanced, in “Testing Server,” be sure to configure URL prefix: http://localhost/ .... See Check the URL Prefix in the Site Definition at Macromedia.com. (Note that the URL prefix does not always need to point to http://localhost/. Right now, we are just using localhost as the troubleshooting web site. The important thing is for “URL prefix” to point to the document root address of whichever testing web site you are connecting to.)

 

2) Make sure that the MySql extension is activated in php.ini. Take the ; off the left side of the line in order to activate: extension=php_mysql.dll

 

3) Make sure that extension_dir = “c:\php\ext” is activated in php.ini, and that it points to the correct directory where php_mysql.dll is located.

For PHP5: extension_dir = “c:\php\ext”

For PHP4: extension_dir = “c:\php" Use this if you followed PHP4 installation instructions and copied all the extensions from c:\php\extensions to c:\php.

 

4) Make sure that PHP is working in Apache server. Does browsing to your http://localhost/phpinfo.php page display PHP graphics and data?

 

BLANK PAGES AND ERROR CODES IN DREAMWEAVER

 

The Dreamweaver Tutorial has you create PHP code on two pages: comments-view.php and comments-add.php. The problem is that after you complete the tutorial instructions, both pages display as blank pages in your Internet browser.

If you’re working on those pages in Dreamweaver, when you click on “Live Data View” you get the following error code:

 

The testing server did not execute any of the scripts in your document. Possible explanations include:

1) The testing server is not running.

2) The testing server ignores files with the ".php" file extension.

3) Your document does not contain any scripts.

 

This is caused by a parsing problem in PHP, i.e the PHP code hangs up and your Apache server gives you a blank page. The solution is to make a change in the php.ini file. Change short_open_tag = on to make it read: short_open_tag = off

 

Good luck. I hope this helps.

 

REFERENCE: http://www.thriftyplaces.com/html/dreamwea...php___apac.html

Link to comment
Share on other sites

  • 4 months later...

everything is correct php and my sql works but when i tried to connect dreamweaver with mysql i can't, i got this message :

 

error undefined....

 

dreamweaver create a connection : here is the file:

 

<?php

# FileName="Connection_php_mysql.htm"

# Type="MYSQL"

# HTTP="true"

$hostname_dbconnection = "localhost";

$database_dbconnection = "name_database";

$username_dbconnection = "user";

$password_dbconnection = "password";

$dbconnection = mysql_pconnect($hostname_dbconnection, $username_dbconnection, $password_dbconnection) or trigger_error(mysql_error(),E_USER_ERROR);

?>

[code]

 

can you help me? I also modified the php.eni :

 

[code]

extension_dir = “d:\php\ext”

[code]

 

thanks, i'm getting crazy.....

 

Link to comment
Share on other sites

  • 4 weeks later...

Hi

I’ve found a solution for this problem

When you want to connect to your database be shore you are online.

In Internet explorer go to file menu and unchecked work offline.

When my Internet explorer is in offline mode I receive "An unidentified error has occured"

 

 

 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

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.