Re: coldfusion 10 Host My Site SQL permission
HMS has updated setting for my account on server to enable CREATE, ALTER, etc. Consider issue resolved > > HMS moved site to CF10 server. For the past 5+ years I've used > scripting quite often to create and alter tables > > for this site. Now when running script I receive error: Executing > the SQL statement is not allowed. > > > > I can confirm datasource, username, password, dbtype are all correct. > > > > > HMS reviewed code and CF Server setting and respond that everything > is set up properly and should work. > > I suspect that the CF datasource is not configured to allow execution > of CREATE and ALTER statements - there's an option right in the > datasource settings for this. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > GSA Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351869 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion 10 Host My Site SQL permission
Just to let everyone know, I believe I resolved this issue for Randy. Appears the CF10 default for creating new DSNs on the server his new site is on, only enables SELECT, INSERT, UPDATE and DELETE by default. So it's necessary to expand the additional settings and enable the additional options. I let our system admins know about this and they are going to look into if this is a CF10 issue or something with that particular installation. I checked our internal CF10 servers and this does not seem to be the case, so it may just be this particular instance. Byron Mann Lead Engineer & Architect | Hosting.com | Delaware On Tue, Jul 10, 2012 at 3:15 PM, Randy Messer wrote: > > HMS moved site to CF10 server. For the past 5+ years I've used scripting > quite often to create and alter tables for this site. Now when running script > I receive error: Executing the SQL statement is not allowed. > > I can confirm datasource, username, password, dbtype are all correct. > > HMS reviewed code and CF Server setting and respond that everything is set up > properly and should work. > > Any ideas? > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351868 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion 10 Host My Site SQL permission
Randy, What is the account number, domain or ticket number and I can take a deeper look. Feel free to contact me directly. ma...@hostmysite.com On Tue, Jul 10, 2012 at 3:15 PM, Randy Messer wrote: > > HMS moved site to CF10 server. For the past 5+ years I've used scripting > quite often to create and alter tables for this site. Now when running script > I receive error: Executing the SQL statement is not allowed. > > I can confirm datasource, username, password, dbtype are all correct. > > HMS reviewed code and CF Server setting and respond that everything is set up > properly and should work. > > Any ideas? > > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351864 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion 10 Host My Site SQL permission
I hope you ASKED to be moved to CF10. On Mon, Jul 9, 2012 at 8:37 PM, Dave Watts wrote: > > > HMS moved site to CF10 server. For the past 5+ years I've used scripting > quite often to create and alter tables > > for this site. Now when running script I receive error: Executing the > SQL statement is not allowed. > > > > I can confirm datasource, username, password, dbtype are all correct. > > > > HMS reviewed code and CF Server setting and respond that everything is > set up properly and should work. > > I suspect that the CF datasource is not configured to allow execution > of CREATE and ALTER statements - there's an option right in the > datasource settings for this. > > Dave Watts, CTO, Fig Leaf Software > http://www.figleaf.com/ > http://training.figleaf.com/ > > Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on > GSA Schedule, and provides the highest caliber vendor-authorized > instruction at our training centers, online, or onsite. > > ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351863 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: coldfusion 10 Host My Site SQL permission
> HMS moved site to CF10 server. For the past 5+ years I've used scripting > quite often to create and alter tables > for this site. Now when running script I receive error: Executing the SQL > statement is not allowed. > > I can confirm datasource, username, password, dbtype are all correct. > > HMS reviewed code and CF Server setting and respond that everything is set up > properly and should work. I suspect that the CF datasource is not configured to allow execution of CREATE and ALTER statements - there's an option right in the datasource settings for this. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ http://training.figleaf.com/ Fig Leaf Software is a Veteran-Owned Small Business (VOSB) on GSA Schedule, and provides the highest caliber vendor-authorized instruction at our training centers, online, or onsite. ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351862 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
coldfusion 10 Host My Site SQL permission
HMS moved site to CF10 server. For the past 5+ years I've used scripting quite often to create and alter tables for this site. Now when running script I receive error: Executing the SQL statement is not allowed. I can confirm datasource, username, password, dbtype are all correct. HMS reviewed code and CF Server setting and respond that everything is set up properly and should work. Any ideas? ~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:351861 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
