Dreamweaver, ColdFusion & MySQL

I’ve been learning these applications in an effort to create my new database driven website and I’m doing pretty good, but I’ve hit a snag and I know there are many that use these applications so maybe someone can help me.

I’ve only used FrontPage in the past, but I’m everything Adobe now and I love it, but the learning curve of these applications is a little higher than I thought it would be.

Here is the deal. I’m working on a test site using dreamweaver with coldfusion where I have my index.cfm, the testing server setup and RDS login verified, but when I go to add the data source (that I must use to continue with my training) I get an error:

Connection verification failed for data source: JumpStart
java.sql.SQLException: Access denied for user ‘admin’@’localhost’ (using password: YES)
The root cause was that: java.sql.SQLException: Access denied for user ‘admin’@’localhost’ (using password: YES)

I do see the four sample sources that comes with coldfusion in the administrator as well as in dreamweaver so that part is installed correctly, but I can’t figure out the problem.

Also, I’d like to use a ms access database, but I’m not sure how to turn it into a .sql or I could just use it in place of the test data source. I did find a tool that sais it make a sql file from a mde, but I can’t understand what is going on there either.

Soooooooooooo as you can see I need some help. I hope that I’ve explained the issue in a manner that will allow someone to troubleshoot with me. Anyone up for it? ” title=”” class=”bbcode_smiley” />