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 vernon.brouss...@la.gov 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

Stored procedures in CF10

2013-07-19 Thread vernon broussard 

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:356246
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