Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Web Programming > Adobe Web Programming > Dreamweaver (all versions)
Password Reminder
| FAQ | Members List | Search | Today's Posts | Mark Forums Read
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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old August 21st, 2006, 01:28 AM
Registered User
Join Date: Aug 2006
Location: JHB, Gauteng, South Africa.
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.

Reply With Quote
  #2 (permalink)  
Old August 25th, 2006, 07:27 AM
Authorized User
Join Date: Aug 2006
Location: , NC, USA.
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!
Reply With Quote

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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

All times are GMT -4. The time now is 05:51 AM.

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