permission denied on object"
Both data sources allow stored procedures.
----- Original Message -----
From: Dave Watts <[EMAIL PROTECTED]>
Date: Thu, 26 Aug 2004 11:56:54 -0400
Subject: RE: CF5 and CFMX storproc problem
To: CF-Talk <[EMAIL PROTECTED]>
> I have a site running on CF5 that makes calls to a store
> procedure. I put that code on a new server running CFMX and I
> get a permissions problem. "Executing stored procedures is
> not allowed."
>
> The data sources are configured the same and use the same
> database user account to connect. The only thing different is
> the version of CF.
>
> Any idea on how do I go about fixing it?
This may seem stupid, but are you absolutely sure the datasources are
configured identically? I would recommend that you recheck your CFMX
datasource - within the Advanced Settings, there's a set of checkboxes that
you can use to limit what kinds of SQL statements are allowed.
Dave Watts, CTO, Fig Leaf Software
http://www.figleaf.com/
phone: 202-797-5496
fax: 202-797-5444________________________________
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
