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.

Toosuave

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!