Solved

Connecting dreamweaver MySQL database

Posted on 2004-10-24
446 Views
Last Modified: 2010-08-05
I desire to create a web with dynamic functionality.  I have dreamweaver MX, MySQL server running with the db designed in MySQL control centre.  In the dreamweaver GUI I can not connect to the database I have created as I don't understand the connection string parameter requirements??? via SQL server connection.
This is required:
Persist Security Info=False;
Data Source=[serverName];
Initial Catalog=[databaseName];
User ID=[username];
Password=[password];
Is this correct?
Persist Security Info=False;
Data Source=[localhost];
Initial Catalog=[film];
User ID=[root];
Password=[];
??? I guess not as it isn't working to establish a connection allowing me to view the deveollped tables.  Can you assist?
At the moment I get the error message:
1) There is no testing server running on the server machine.
2) The testing server specified for this site does not mP TO THE HTTP://LOCALHOST/VISION/_MMsERVERsCRIPTS/mmhttpdb.ASP url.
Verify that the URL Prefix maps to the root of the site.
Can you assist?

  Initially the database panel is set to ASP.NET C# as requested, yet when I open a file the database document tile switches to ASP.NET VB.  I want to work in C#, how do I work to correct this also?
0
Question by:JarrodJohn
    10 Comments
     
    LVL 14

    Accepted Solution

    by:
    0
     
    LVL 3

    Expert Comment

    by:nan1217
    1.)  It looks like the path you are using to point to the database is local and it's not finding it there.  If it's located on a different server, then the path needs to represent that.
    2.)  You mention you are using a SQL Server connection but a MySQL database.  SQL Server and MySQL are different - perhaps that's part of the problem as well. Refer to the following article on using Dreamweaver w/MySQL.  http://www.macromedia.com/support/dreamweaver/ts/documents/mysql_config.htm
    0
     

    Author Comment

    by:JarrodJohn
    Thankyou hhammash, the site you reccomended

    http://paul.ecommerce.hct.ac.ae/tutorials/dwmx-php/dwmxphp.htm


     was very helpful..  But problem not yet solved for me can you help.  At step 23, I have no problems unitil I attempt to test the URL.  All files are held in the c/interpub/wwwroot/ (in a folder called) Vision.
    When I test the URL I get this message:

    DW can't use the prefix you entered to display live data. Please double check your site configuration pr click help for more info on how to correct this problem.  HTTP Error:12029

    the URL I attempt to use is http://localhost/Vision/

    Why is this not working?
    0
     
    LVL 3

    Expert Comment

    by:nan1217
    1.)  Sometimes using "localhost" doesn't work.  Try using 127.0.0.1 instead.
    2.)  Try setting up the "Vision" folder/path in IIS.
    0
     
    LVL 14

    Expert Comment

    by:hhammash
    I agree with nan1217

    I usually use 127.0.0.1

    Also,  have you created the virtual directory in IIS?

    hhammash
    0
     

    Author Comment

    by:JarrodJohn
    Thankyou nan1217 & hhammash,
    With the 127.0.0.1, you suggest I've tried a few times as  http://localhost/Vision/ doesn't cut it.
    But like this  http://127.0.0.1/Vision/ doesn't work or 127.0.0.1 by itself doesn't work.  What is the full URL prefix for 127.0.0.1???  And please any suggestions on setting up the folder/path in IIS / creating the virtual directory in IIS?
    0
     
    LVL 3

    Expert Comment

    by:nan1217
    Your URL of http://127.0.0.1/Vision/ is the correct one to use.

    To setup in IIS (and this assumes use of XP - modify instructions for another operating system)

    Go to Start>Settings>Control Panel>Administrative Tools>Internet Information Services

    Expand all the trees on the left until you see the branch that says "Default Web Site."  Right-click on the words "Default Web Site" and choose New>Virtual Directory.  Follow the wizard, naming the site what you wish (whatever you choose will be what you use to browse with so it would be http://127.0.0.1/whatevernameyouchoose/) and then choosing the directory where the files reside.

    Browse to http://127.0.0.1/whatevernameyouchoose/ and see if that works.
    0
     

    Author Comment

    by:JarrodJohn
    OK much thank you as your help has been excellent.  Discovery is, don't waste time trying to get it together with an early verion of IIS.  Download a later version very necessary for good function.  So next time I know, I hope you have recieved 500 points with each comment you have made to assist me or is it set up so only the first response gets the 500??
    I am sure I may resort to your assistance again but sincerely hope it isn't in an immediate future.  Nevertheless knowing the support is here if needed is bloody briliant.  Again, thank you
    Jarrod Out
    0
     
    LVL 3

    Expert Comment

    by:nan1217
    JarrodJohn,
    You need to award the points with a grade.  If you aware a grade of A, the accepted answer gets 4 times the amount of points.
    0
     
    LVL 3

    Expert Comment

    by:nan1217
    ^^^Oh, and you can split the points between multiple users but too late for that as you have already accepted an answer.
    0

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone. Privacy Policy Terms of Use

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Introduction HTML checkboxes provide the perfect way for a web developer to receive client input when the client's options might be none, one or many.  But the PHP code for processing the checkboxes can be confusing at first.  What if a checkbox is…
    Introduction Many web sites contain image galleries; a common design for these galleries includes a page with a collection of thumbnail images.  You can click on each of the thumbnail images to see the larger version of the image.  This is easily i…
    The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…
    This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

    875 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

    15 Experts available now in Live!

    Get 1:1 Help Now