Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Connecting dreamweaver MySQL database

Posted on 2004-10-24
10
Medium Priority
?
453 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
Comment
Question by:JarrodJohn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
10 Comments
 
LVL 14

Accepted Solution

by:
hhammash earned 1500 total points
ID: 12395271
0
 
LVL 3

Expert Comment

by:nan1217
ID: 12395732
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
ID: 12405361
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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
LVL 3

Expert Comment

by:nan1217
ID: 12405382
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
ID: 12405423
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
ID: 12408488
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
ID: 12410426
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
ID: 12419804
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
ID: 12421527
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
ID: 12421540
^^^Oh, and you can split the points between multiple users but too late for that as you have already accepted an answer.
0

Featured Post

Looking for a new Web Host?

Lunarpages' assortment of hosting products and solutions ensure a perfect fit for anyone looking to get their vision or products to market. Our award winning customer support and 30-day money back guarantee show the pride we take in being the industry's premier MSP.

Question has a verified solution.

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

FAQ pages provide a simple way for you to supply and for customers to find answers to the most common questions about your company. Here are six reasons why your company website should have a FAQ page
Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.
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.
Suggested Courses

604 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