Jim, I'll try out upload and let you know what I see.
I'm still a bit confused on the DSNs.
The GoDaddy control panel thingy lets me create a database and then I have a
couple of check boxes to optionally create a DSN and a CF DSN. I choose both
and also choose to create a username and password. I've also tried a few
other combinations.
Would you mind trying something, if you run a cfquery using the minimal
attributes does it still work? For example:
<cfquery name="validuser" datasource="#Request.dbsource#">
Whatever
</cfquery>
I'm really really miffed that GoDaddy can't even tell me what is required to
hook up to a DSN. They don't have a clue.
Cheers.
-----Original Message-----
From: Jim Wright [mailto:[EMAIL PROTECTED]
Sent: Thursday, 23 March 2006 6:25 AM
To: CF-Talk
Subject: Re: GoDaddy & MySQL... does it work?
this is the start to a query that works...note that while I have the
user and password variables shown, I inadvertantly created this DSN
with the user/pass included. The request variables for those are just
assigned empty strings.
<cfquery name="validuser" datasource="#Request.dbsource#"
dbtype="ODBC" username="#Request.dbuser#" password="#Request.dbpass#">
Interesting that cffile works for you. Have you done an upload?
On 3/22/06, Andrew Stevens <[EMAIL PROTECTED]> wrote:
> I'm happy to report cffile is working, ahh the irony.
>
> Jim, would you mind posting an example of your cfquery syntax? I've tried
> both dsn types (plus anything else that looks like a dsn).
>
> Cheers.
>
> -----Original Message-----
> From: Jim Wright [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, 22 March 2006 1:25 AM
> To: CF-Talk
> Subject: Re: GoDaddy & MySQL... does it work?
>
> Not related to the DSN issue, but one of my clients had a small throw
> away site that we decided to host at godaddy as a trial...I found out
> that they don't support cffile, which handicapped the app a bit.
> Cffile is not listed in their list of disabled tags (or wasn't at that
> time, I haven't looked again lately).
>
> on the DSN issue...I have a MySQL DSN working fine there. In there
> management interface, they allow you to create a DSN or a ColdFusion
> DSN...is it possible that you created the latter?
>
> On 3/21/06, Andrew Stevens <[EMAIL PROTECTED]> wrote:
> > I'm embarrassed to ask this. Has anyone used the MX7 hosting at GoDaddy?
> > (Well, I wanted to see how shit it really was.)
> >
> >
> >
> > I can't for the life of me get a MySQL DSN to work. Has anyone done it?
> > Despite hours of tooling around, all I get is "Data source
mysqlcf_MrBuzzy
> > could not be found". I can also cause a null pointer and a sql/sandbox
> > access denied message. This all depends on the different attributes I
use
> in
> > <cfquery>.
> >
> >
> >
> > A little help would be great.
> >
> >
> >
> > Cheers,
> >
> > AS
> >
> >
> >
> > Ps: yes I've tried godaddy support.
> >
> > Pps: yes, I should go do a better hosting company.
> >
> >
> >
> >
> >
> >
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236112
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
