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