I hate to revive an old thread, but I did get cffile to work, by finally getting someone at GoDaddy's tech support who aked their admin about it. It was a sandbox issue, and resolved in 2-3 hours. My problem with GoDaddy's hosting is this. I was told after a long drawn out tech support request that they will not support cfqueryparam with MS SQL Server databases since it needs to access sp_prepexec in the master database. Is there anyone using GoDaddy with a shared account that has this working sucessfully. I can't see in any way, shape, or form see how they could not support this.
Here's the text of the final email I received. Discussion Notes Support Staff Response Dear John: After further researching the issue(s) at hand, we have determined the following: The line "EXECUTE permission denied on object 'sp_prepexec', database 'master', owner 'dbo'." shows that the database is attempting to work with the master database of the server. Due to this, the cfqueryparam feature will not work within our shared hosting environment SQL (though it should work with a locally controlled Access database). We apologize for any inconvience this may cause in regards to your site deployment. If you have absolute need of this feature, you may wish to consider our Virtual Dedicated or Dedicated server solutions. Bear in mind that these are not managed servers. Previous server administration experience is recommended should you opt to move to one of these solutions. Should you require further assistance on this or any other issue, don't hesitate to contact us any time of the day or night at (480) 505-8877. Or, if you prefer email, you can send your questions or comments to [EMAIL PROTECTED] Sincerely, Drew C. Advanced Hosting Support Customer Inquiry >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: >in ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:236366 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
