Hello all - I was wondering if there is any difference in how a CFC would access a database vs how a regular CFM page would? I don't see why there would be. Yet I have a site in development which throws a database permissions error on the one CFC page but not any other pages. I can not figure out what the difference could be.
This is CFMX 7 and mySQL 5. (I am using SQL Server locally, and locally I have no problems.) Until I get the IT person there to enable robust exception info and give me access to the CF logs, I have little info to go on. But I get a basic permissions error as follows: SELECT command denied to user 'mywebuser'@'localhost' for table 'mytable' I have set up a test page which first hits this table with a regular cfquery and then calls a function in the CFC to access the same table. The regular cfquery works fine. The function call throws the above error. The CFC is set to use the same datasource, username and password. I have double and triple checked that. I am completely confused. Anyone? Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284630 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
