Dreamweaver SQL connection with PHP

Posted on 2012-09-16
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:amucinobluedot
    LVL 82

    Assisted Solution

    by:Dave Baldwin
    You need to read the Windows Help file for the Microsoft PHP SQL driver.   Another version of the instructions is here:  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
    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

    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

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

    Probably not.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    Suggested Solutions

    Title # Comments Views Activity
    Record Button 3 211
    HELP.. background images in eblasting 25 378
    Debug application start 2 271
    Easy way to swap image out on page load 8 164
    For those who don't know, Adobe Dreamweaver is a popular commercial web editor that enables you to design, build and manage complex websites. The editor is a WYSIWYG (What You See Is What You Get) web editor, which means that you can create your web…
    This article is very specific and is only intended to help if you are installing Dreamweaver 8 in a Windows 7 environment with Office 2007 installed.   I'm not sure why Microsoft tends to release OS' that should not be released but they do.  Windows…
    This video discusses moving either the default database or any database to a new volume.
    Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now