Connecting to godaddy.com database

[Fabio_scopel]

How to connect to godaddy.com database using ColdFusion MX?
How to connect to MySQL in the godaddy.com shared hosting account using coldfusion.

Guys I am seriously going crazy. I cannot belive that I cant find a place on the NET the actually shows examples of how to connect to godaddy.com MySQL databases..

I called them and they are seriously clueless. They have not idea how to guide me thru the ColdFusion setup. I tried their help support pages, here are the links:

L=Entire Help center on ColdFusion]http://help.godaddy.com/search.php?SearchTerms=coldfusion&page=1&&

These help for nothing..... They send me connecting strings, I DO NOT WANT STRINGS. I want to connect thru the ColdFusion Administration - Datasources -
Well enough complaning. This is what I need:
ANYONE out there using godaddy.com and Coldfusion MX 7 thas has successfully connected to their MySQL database on the godaddy.com shared hosting servers please give me and example of how you did it.

I just cannot figure it out. Contact me please Fabio.scopel@hotmail.com or just post it here for everyone to see it.
I Sincerely thank you for your time.
Fabio.

[Newsgroup_User]

Just to make sure I understand this. GoDaddy is hosting you mySQL
database, but not your ColdFusion server.

Fabio.scopel wrote:
> How to connect to godaddy.com database using ColdFusion MX?
> How to connect to MySQL in the godaddy.com shared hosting account using
> coldfusion.
>
> Guys I am seriously going crazy. I cannot belive that I cant find a place on
> the NET the actually shows examples of how to connect to godaddy.com MySQL
> databases..
>
> I called them and they are seriously clueless. They have not idea how to
> guide me thru the ColdFusion setup. I tried their help support pages, here are
> the links:
>
> L=Entire Help center on
> ColdFusion]http://help.godaddy.com/search.php?SearchTerms=coldfusion&page=1&&
>
> These help for nothing..... They send me connecting strings, I DO NOT WANT
> STRINGS. I want to connect thru the ColdFusion Administration - Datasources -
> Well enough complaning. This is what I need:
> ANYONE out there using godaddy.com and Coldfusion MX 7 thas has successfully
> connected to their MySQL database on the godaddy.com shared hosting servers
> please give me and example of how you did it.
>
> I just cannot figure it out. Contact me please Fabio.scopel@hotmail.com or
> just post it here for everyone to see it.
> I Sincerely thank you for your time.
> Fabio.
>
>
>

[liquid_One]

If the answer to Ian's question is yes, then you cannot do it.
I have already spoke with them about the possibility, and they quickly shot it down. Before I even called, I had tried to do it manually, via creating an alias in sql server. However, they have some setting where it will only comunicate locally. Meaning not only do you have to use there CF server, but you also have to use there java version of an enterprise manager and query analyzer.
good luck,
Mike

[Wolfespring]

I am having the same issue. I have been coding with ASP for years and PHP recently and now I am trying to get into CF.

Godaddy is hosting my site on a linux box, shared environment. I have PHP and CF server installed in my account. I created a DB with their tool and there was a check box for creating a CF DSN and I checked it and I know what the DSN name is. I also know the godaddy MySQL Host name.

I thought that I needed to put this information into my local CF Admin pannel so that I could access it, but it doesn't want to connect that way. The default port number was 3306 but that doesn't seem to work so I tried it without a port number but that doesn't connect either.

The DW 8 help file said that in the databases window in DW I should see a '+' symbol and can use that to connect if I am running CF MX 7 which godaddy is running as am I locally.

What am I missing here? Do I have to setup the same data tables and dsn on my local box to work in DW?

Any help for a CF newbie would be MUCH appreciated.

Thanks,
Jeremy

[Abinidi]

Its Godaddy. You need to ditch them and get a real host.
They sell domains, that is what they know. They dont know jack about hosting.

Look into Crystaltech.com or Hostmysite.com. Either one will take care of you.

Connection a mysql database to Cf is a no brainer...as long as the person you are dealing with on the other side has a brain :)

[liquid_One]

Actually, godaddy.com is in the top 3 shared hosting companies in the world. While they may be good, Crystaltech and hostmysite arent even in the top 20. As of sep 2005 they were the number 1 shared web host in the world.
http://www.hostsearch.com/news/go_daddy_software_news_3506.asp
They absolutely know what they are talking about, however they are also very concerned about security, and having computers connecting to their servers is a security risk. They have a java web tool to handle all of the db and cf admin needs you may have, and ive never run into any problems with them. Not to mention they are the cheapest by far. . .

[Wolfespring]

thanks for the input. I was able to get things working when i created a mySQL db on my local box and set the same DSN name and user pass as on my godaddy account. then i was able to work with everything well in CF locally and upload and it worked fine.

Liquid One, you mentioned that they have a java tool for CF Admin, but i haven't noticed it in my account. Can you point me in the right direction for this tool?

Thanks,
Jeremy