[Last Call] Learn how to a build a cloud-first strategyRegister Now


Dreamweaver SQL connection with PHP

Posted on 2012-09-16
Medium Priority
Last Modified: 2012-09-18
I just downloaded and installed the drivers to connect PHP with MS SQL 2008.
I went to DW but there is no option to create a connection other than MySQL. Is there a way to create a connection maybe manually so that I can use it to create recordsets and connect to SQL 2008 or maybe an extension that allows this ?
Question by:Aleks
  • 2
LVL 84

Assisted Solution

by:Dave Baldwin
Dave Baldwin earned 668 total points
ID: 38403911
You need to read the Windows Help file for the Microsoft PHP SQL driver.   Another version of the instructions is here: http://us3.php.net/manual/en/book.sqlsrv.php  I don't think Dreamweaver knows anything about this.  Make sure you have downloaded and installed the SQL Native Client so the drivers will work.  This assumes you are running on Windows.
LVL 70

Assisted Solution

by:Jason C. Levine
Jason C. Levine earned 1332 total points
ID: 38403947
Dreamweaver only supports PHP/MySQL connections via the wizards.  You have to write your own connection code if using a database other than MySQL.

Author Comment

ID: 38406744
If I do, will I be able to create recordsets, etc via Dreamweaver ?

If so, how can I write a connection using PHP into a MS SQL server database ?
LVL 70

Accepted Solution

Jason C. Levine earned 1332 total points
ID: 38407079
If I do, will I be able to create recordsets, etc via Dreamweaver ?

Probably not.

Featured Post

How to Use the Help Bell

Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention.  Check out this how-to article for more information.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I still run into .cgi files every now and then. In some instances, I actually prefer the simplicity of a .cgi script to other options. Since I use DreamWeaver extensively, what I needed was a way to open .cgi scripts in Dreamweaver. And I wanted to …
Adobe Dreamweaver CS5 is a WYSIWYG web page editor that has advanced HTML, CSS, and Javascript rendering functionality and is probably the most well-known HTML editor available. Much of Dreamweaver's appeal centers around the Design View interfac…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
Suggested Courses

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question