I am setting up a dynamic website using Dreamweaver and Coldfusion. I will be using the MySQL database on the server. There are many things I do not understand. What is the best way to develop my website using MySQL, do I open a data source in Coldfusion. Then while working in Dreamweaver I make the database connections directly to the MySQL database on the server? I tried to set-up the data source in Coldfusion but there was an error, what is the path to my database on the server? Or is there a better way to do this?
