Using the minimal attributes worked fine for me. On 3/23/06, Andrew Stevens <[EMAIL PROTECTED]> wrote: > 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:236113 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