That's basically what I told them. They will never be taken seriously by anyone in the ColdFusion community.
I submitted that incident back at the end of March. This was for one of my clients, who hosts with them. SQL and cfqueryparam works fine on every other ColdFusion host who actually knows what they are doing. This is the error I get. I suggested maybe they might want to contact Macromedia to ask them how to set things up correctly, but I think that fell on deaf ears. I also suggested they change the article which states what tags they support since it was misleading. [Macromedia][SQLServer JDBC Driver][SQLServer]EXECUTE permission denied on object 'sp_prepexec', database 'master', owner 'dbo'. Also I was the one who posted about getting the issue resolved with cffile, but that was just a sandbox problem. John -----Original Message----- From: Mark A Kruger [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 1:23 PM To: CF-Talk Subject: RE: Coldfusion with Godaddy I second that John, They are misinformed. I suspect their information came from a misconfigured DSN setting. For example, If I set up a user "bob" and didn't change "default database" for him, then I set up a JDBC connection without specifying the database I wanted to connect to - it would try to connect to master (which is the default default database for any new user), but it would fail because master doesn't allow direct manipulation of data. Instead it comes with a set of SP's (sort of a like an API) for making any changes. I would be very surprised if their information was accurate. More to the point, they are trading down when they deny cfqueryparam - not trading up. A site that doesn't user cfqueryparam is going to be less secure, slower, and will not be able to leverage the DB like it should. -mark -----Original Message----- From: Snake [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 11:57 AM To: CF-Talk Subject: RE: Coldfusion with Godaddy That's interesting, we have no such problem on our SQL servers, CFQUERYPARAM works fine, and every user only has access to their own database. -----Original Message----- From: John Rossi [mailto:[EMAIL PROTECTED] Sent: 05 May 2006 17:47 To: CF-Talk Subject: RE: Coldfusion with Godaddy That's not entirely true. They do not, at least they told me they can't allow me to use cfqueryparam with sql server in shared hosting. Here's the final response I got from them. 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 -----Original Message----- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 12:37 PM To: CF-Talk Subject: RE: Coldfusion with Godaddy They guy on the phone just told me that they support all tags out of the box except cfexecute and cfregistry He also said that they will not install custom tags for you, but I can still run it in my own directory, right? ~Brad -----Original Message----- From: Andy Matthews [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 11:31 AM To: CF-Talk Subject: RE: Coldfusion with Godaddy I would think they would. They had a help section about Coldfusion when they first released it. In fact, if you search this list on the website you should be able to find my post with all of the direct links. <!----------------//------ andy matthews web developer certified advanced coldfusion programmer ICGLink, Inc. [EMAIL PROTECTED] 615.370.1530 x737 --------------//---------> -----Original Message----- From: Brad Wood [mailto:[EMAIL PROTECTED] Sent: Friday, May 05, 2006 11:23 AM To: CF-Talk Subject: RE: Coldfusion with Godaddy I'm on the phone now trying to get a list of restricted tags from them.. Does any one know if they publish that? ~Brad -----Original Message----- From: Brad Wood Sent: Friday, May 05, 2006 11:04 AM To: CF-Talk Subject: RE: Coldfusion with Godaddy Godaddy does CF now? That is cool. I have asked them several times if they plan on hosting CF sites and they have always told me no. My personal site is pretty basic and I have been looking around for some cheap hosting to move it to. Since my domains are already registered with godaddy, I might give their hosting a whirl... ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:239664 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
