Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Web Programming > Adobe Web Programming > Dreamweaver (all versions)
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Dreamweaver (all versions) section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old August 21st, 2006, 01:28 AM
Registered User
Join Date: Aug 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Recordset error in Dreamweaver Using PHP and MySQL

 Hi out there

I hope someone can help me!!

I am a newbee with PHP and MySQL.

I am running winXP home with apache mySQL and PHP and as far as I know they are all working. My webserver test works and so does my PHP test and I have checked my services and MySQL seems to be started. I have loaded all the latest versions of the applicable software (PHP, Apache, Mysql, Mysql ODBC Connector, Dreamweaver).

Here's the problem; when I try to create a recordset a "error code 500" pops up in (DW) and I cannot view the Database data.
I have a connection and I can see the tables and fields in the database pannel in (DW) I can insert records into the DB and I can read from it (eg, userlogin).

Can anyone please help me on this or point me in the right direction on solving this problem. I have googled and searched the web for about three weeks and have come up with little help.

Old August 25th, 2006, 07:27 AM
Authorized User
Join Date: Aug 2006
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts

Hi there,

I had similar problems recently with ASP, SQL and DW, which have resolved. I am pretty new to ASP and SQL as well.

1.) Excellent book I am using: Dreamweaver Advanced (Peachpit Press), which I ordered through a local bookstore. This book contains a lot of examples on just what you're doing and a lot of examples with instructions referring to PHP.
2.) They specifically mention when displaying recordsets "If you get an error that begins, "Failed opening Connections/" and you are using PHP, you have not yet uploaded the Connections folder."
3.) My own suggestion after my experience with similar problems with ASP and SQL and DW:
I set up a custom connection string, instead of using the System DSN and that was successful. "Driver={SQL Server};Server=ServerNameNumber;DBQ=D:\INETPUB\Dat abases\SQL Databases\MSSQL\data\website_Data.MDF;UID=UserName ;PWD=Password;" I selected "Using Driver on this Machine" when I coded the connection string from the Applications Panel, Databases tab.

DW (I am using MX at work) online help actually has some pretty good documentation on this issue. They actually have a section called "Database Connections for PHP Developers" - while I use ASP with the sites and databases here, this may help you.

Hope you have figured it out or if not, that this helps!

Similar Threads
Thread Thread Starter Forum Replies Last Post
Connect php to mysql using dreamweaver Nicholsen MySQL 1 December 14th, 2006 07:26 AM
Mysql error in checkout2.php in E-Commerce example JECovill BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 1 May 29th, 2006 09:44 PM
dreamweaver(Database/recordset error ) Divya Kedia Dreamweaver (all versions) 0 March 18th, 2006 10:39 AM
php, mysql, apache & dreamweaver seanhsueh PHP Databases 1 December 9th, 2005 08:12 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.