goingcrazy Posted September 3, 2004 Share Posted September 3, 2004 no idea what's going wrong... i was following the dreamweaver tutorial for php but i just can't get the connection working. i've read every help i could find but nothing helps. i'm running: Dreamweaver MX 2004 IIS v5.1 PHP v5.0.1 MySQL v4.0.20 any ideas? Quote Link to comment https://forums.phpfreaks.com/topic/1948-dreamweaver-mysql-connection/ Share on other sites More sharing options...
olaf Posted September 3, 2004 Share Posted September 3, 2004 is the connection file created by dreamweaver? If yes show it here... Quote Link to comment https://forums.phpfreaks.com/topic/1948-dreamweaver-mysql-connection/#findComment-6339 Share on other sites More sharing options...
goingcrazy Posted September 4, 2004 Author Share Posted September 4, 2004 not sure what you mean by a connection file... Quote Link to comment https://forums.phpfreaks.com/topic/1948-dreamweaver-mysql-connection/#findComment-6344 Share on other sites More sharing options...
andy Posted September 9, 2004 Share Posted September 9, 2004 It may be the same problem I used to get. In your testing server window in the site setup, make sure that you have simply http://www.yoursite.com as dreamweaver puts in something like http://ftp.yoursite.com/web or whatever your directory is (htdocs, www etc) This one drove me mad for a while Andy Quote Link to comment https://forums.phpfreaks.com/topic/1948-dreamweaver-mysql-connection/#findComment-6368 Share on other sites More sharing options...
upit Posted September 9, 2004 Share Posted September 9, 2004 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 ? Quote Link to comment https://forums.phpfreaks.com/topic/1948-dreamweaver-mysql-connection/#findComment-6370 Share on other sites More sharing options...
haavarl Posted November 9, 2004 Share Posted November 9, 2004 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 Quote Link to comment https://forums.phpfreaks.com/topic/1948-dreamweaver-mysql-connection/#findComment-6667 Share on other sites More sharing options...
Jehozadak Posted November 26, 2004 Share Posted November 26, 2004 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!!!!!!!!! Quote Link to comment https://forums.phpfreaks.com/topic/1948-dreamweaver-mysql-connection/#findComment-6753 Share on other sites More sharing options...
neongtr Posted January 10, 2005 Share Posted January 10, 2005 i have the sample problem too I read and read many forum and tried out varies suggestions and none of them work. I am thinking may be design the php page with dmx and hand code the connection bit. Quote Link to comment https://forums.phpfreaks.com/topic/1948-dreamweaver-mysql-connection/#findComment-6955 Share on other sites More sharing options...
neongtr Posted January 12, 2005 Share Posted January 12, 2005 I use WAMP package and it works for me... connect up straight away Quote Link to comment https://forums.phpfreaks.com/topic/1948-dreamweaver-mysql-connection/#findComment-6968 Share on other sites More sharing options...
newbie1 Posted February 4, 2005 Share Posted February 4, 2005 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 Quote Link to comment https://forums.phpfreaks.com/topic/1948-dreamweaver-mysql-connection/#findComment-7087 Share on other sites More sharing options...
adarhol Posted June 28, 2005 Share Posted June 28, 2005 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..... Quote Link to comment https://forums.phpfreaks.com/topic/1948-dreamweaver-mysql-connection/#findComment-7797 Share on other sites More sharing options...
ma3743 Posted July 21, 2005 Share Posted July 21, 2005 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" Quote Link to comment https://forums.phpfreaks.com/topic/1948-dreamweaver-mysql-connection/#findComment-7957 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.