Issues with CF 8

Greensquid wrote:
> Database: E:/ABC/ABC.mwb

No, Coldfusion wont look in any arbitrary folder. As I said above, it will only look in the directory {MySQL_HOME}\data\.

> Server:Localhost:8500
> Port:3306

No, you wrongly use 2 ports. Here you need just MySQL's port, not Coldfusion's. It usually is 3306. Therefore enter

Server: localhost
(or Server: 127.0.0.1)

and

Port: 3306

Greensquid,

Let's cut the chase. MySQL installs by default a database called 'test'. Use it to test your settings.

For example, on my machine, MySQL databases are installed by default in the folder C:\Program Files\MySQL\MySQL Server 5.1\data\. Databases are represented as directories within the data folder.

I have verified that there is indeed a folder named 'test' in the data directory. The corresponding settings would therefore be

CF Data Source Name:ABC
Database: test
Server:127.0.0.1
Port:3306
Username: Root Login
Password:Root Password

http://dev.mysql.com/doc/refman/5.1/en/database-use.html

You can't have this line:
Database: E:/ABC/ABC.mwb

It should be something like:
Database: MyDB

Where MyDB corresponds to a database in MySQL (matches one of the names that you get from a SHOW DATABASES; command), NOT A FILE ON YOUR HARD DRIVE!!!!!

If you haven't actually created a database in MySQL, read this:
http://dev.mysql.com/doc/refman/5.1/en/creating-database.html

Did you follow a how-to or a walkthrough when you installed MySQL and set it up? If so, please post the link you used. That'll help.

"simply because the error pops up when I'm trying to set it up."

Very clearly and distinctly, explain exactly what you are doing when this error pops up. That's what I'm trying to get out of you. Are you in the Coldfusion Administrator? What page? What are you entering in each field?

Let me speak plainly. The more information you give us on how you're seeing this error, the easier it is for us to help you and not simply get frustrated and give up. Post back with as much detailed information as possible about how exactly you are getting the error. What are you doing when it comes up? What are you clicking on? What page are you on in your browser?

Greensquid wrote:
> That didn't change anything, I guess I need Step-by-step
> instructions on how to set up a dns

Setting up MySQL in the Administrator is easy. I think it would save a lot of time if you let us know the steps you followed.

> I keep getting this error "java.sql.SQLException"
Very likely due to the wrong combination of username and password. You should use a valid MySQL username and password.

If you have a firewall, make sure to add exception to the MySQL port. Also, you can turn off your firewall then try to create a datasource. Make sure the service for MySQL is running and you can telnet.

Good Luck
Mamdoh

http://www.cfscreencast.com/screencast/episod2/index.html

This came up when googling for: "coldfusion setting up a mysql datasource"

So what is that last remaining error message and what are you trying to do when you encounter it?

> I am a web developer, I have no Idea how to setup a CF Server, I know the
> syntax of CF when developing but the server side of things has always been done
> for me, I have recently downloaded CF8 by can't get it to form a dns with
> MySQL, I keep getting this error "java.sql.SQLException" is there anyone who
> can help me solve this problem?

Have you done anything as obvious as googling the error message, or
googling how to set up a MySQL datasource (for the purposes of searching,
it's "DSN" not "DNS", btw).

I'm loath to help someone who doesn't seem to have invested much time in
trying to help themselves, before expecting people here to do it for them.

Have a hunt around the place for pre-existing docs (trust me, this has all
been covered and covered again already), and when and if you find some, do
what it says and then still have problems: come back to us.

If you show some evidence of having trying to sort it out yourself and are
still having problems, I'm happy to help. I'll keep an eye on this
thread...

--
Adam