Re: Stored procedures in CF10

2013-07-20 Thread Byron Mann 

By chance did you recently migrate and are using different credentials?
Possibly just a database permissions issue.

Byron Mann
Lead Engineer & Architect
HostMySite.com
On Jul 19, 2013 5:47 PM, "vernon broussard"  wrote:

>
> In ColdFusion 10 when trying to access one of our gateway applications now
> I get an error saying that ‘Executing stored procedures is not allowed.’
> How do you enable stored procedures in this version? Is it part of the
> install or can it be changed within administrator?
> Thanks v
>
> 

~|
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:356248
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm

Re: Stored procedures in CF10

2013-07-19 Thread Dave Watts 

> In ColdFusion 10 when trying to access one of our gateway applications now I 
> get an error saying that ‘Executing stored
> procedures is not allowed.’ How do you enable stored procedures in this 
> version? Is it part of the install or can it be changed
> within administrator?

CF 10 does not by default prevent you from executing stored
procedures. However, you may disable execution of stored procedures
within the datasource advanced settings, or within the database itself
for the user account in question. So those are the places I'd look
first.

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 onsit

~|
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:356247
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm