Connect to MySql Db from ASP driven website using Dreamweaver

Posted on 2006-04-27
Last Modified: 2010-04-25
I have looked all over to find a way to connect to a MySql db using DW. I understand that Macromedia does not support connection to MySql from an ASP driven website. I have an IP address + user information to MySql db.

Question by:nilu-72

    Accepted Solution

    i believe you can use the ODBC connector from the MYSQL site (downloads area) to create a datasource connection which you can access using ASP.

    Expert Comment

    Also Interakt Phakt Extension ( will allow you to connect to mysql the PHakt extension is Free.

    Author Comment

    I am using this string to connect:
    Dim objConn, objRS
    Set objConn = Server.CreateObject("ADODB.Connection")
    Set objRS = Server.CreateObject("ADODB.Recordset")
    objConn.ConnectionString="DRIVER={MySQL ODBC 3.51 Driver};;DATABASE=volare;UID=volare;PWD=xxxxxx;"
    In dreamweaver it shows that the connection is a succes, but I can not see the tables.

    The Phakt extension is only for PHP sites. This is an ASP website.
    LVL 70

    Expert Comment

    by:Jason C. Levine

    cmc2006 is right,  you need to use the mysql odbc connector to use mysql with asp.

    LVL 3

    Expert Comment

    LVL 70

    Expert Comment

    by:Jason C. Levine
    Hi mrichmon,

    cmc2006 has the answer.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    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…
    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…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…

    745 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

    20 Experts available now in Live!

    Get 1:1 Help Now