Simple cfquery dsn connection...

[StearmanDriver]

Hi,

Still struggling to get a DSN connection working on a GoDaddy server. This works just fine on my local machine with testing server running, but I just want to make sure I'm not missing anything that would be required for this to work on a remote server. I've built a couple practice CF sites locally, but this is my first attempt to publish one.

Anyway, here's the cfquery:
<cfquery name="rs_TEST" datasource="mysqlcf_oldoakstesttwo">
SELECT *
FROM table01
</cfquery>

Just a simple request to return records from table 1 of a sample database. The DSN is the name GoDaddy's control panel assigned to my database. I created a DSN with the same name locally, and it works. I get a security error when I publish. From what I understand, GD doesn't require a username or password in the DSN connection, but I tried that anyway... still no dice. I'm really starting to suspect the problem is on their end, but just want to make sure this should work.

So, does it look ok?

Thanks guys...
Joe

[Dan_Bracuk]

The syntax is correct.

[Newsgroup_User]

I would contact godaddy and tell them the security error you are getting.

The <cfquery> is fine

--
Ken Ford
Adobe Community Expert Dreamweaver/ColdFusion
Adobe Certified Expert - Dreamweaver CS3
Fordwebs, LLC
http://www.fordwebs.com


"StearmanDriver" <webforumsuser@macromedia.com> wrote in message
news:ga2inq$123$1@forums.macromedia.com...
> Hi,
>
> Still struggling to get a DSN connection working on a GoDaddy server.
> This
> works just fine on my local machine with testing server running, but I
> just
> want to make sure I'm not missing anything that would be required for this
> to
> work on a remote server. I've built a couple practice CF sites locally,
> but
> this is my first attempt to publish one.
>
> Anyway, here's the cfquery:
> <cfquery name="rs_TEST" datasource="mysqlcf_oldoakstesttwo">
> SELECT *
> FROM table01
> </cfquery>
>
> Just a simple request to return records from table 1 of a sample database.
> The DSN is the name GoDaddy's control panel assigned to my database. I
> created
> a DSN with the same name locally, and it works. I get a security error
> when I
> publish. From what I understand, GD doesn't require a username or
> password in
> the DSN connection, but I tried that anyway... still no dice. I'm really
> starting to suspect the problem is on their end, but just want to make
> sure
> this should work.
>
> So, does it look ok?
>
> Thanks guys...
> Joe
>

[StearmanDriver]

Thanks guys. I've been trading support emails with GD for the last couple days. It's been an entertaining experience so far, but now I've been notified that "due to the complex nature of my difficulty, it has been forwarded on to advanced tech support." Maybe, just maybe, they know what THEY'RE doing. We'll see.

Joe

[Newsgroup_User]

yes...
and now you know: if you serious about your cf website - find a serious
cf host for it.

i would maybe consider hosting my personal site with godaddy... maybe...
but for anything more than a personal play-site i would look for a
proper host who actually knows cf... if i didn't have my own vps.

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

[fargond]

Good posts. It was really helpful for me.