Hello all, Has anyone actually gotten a database link working from a CF server to a second oracle server?
I'm trying a connection string: create database link prodlink connect to <myusername> identified by <mypass> using 'PROD'; and getting: Error Executing Database Query. Executing the SQL statement is not allowed. The problem is that I am not the admin and have little oracle experience. The DBA has little CF (or even web) experience. It sounds like to me there is a permissions error in either the oracle DB, or in CF. I'm not sure which. Of course i'm crunched for time. Any ideas? Thank you, Dave Powell ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:335973 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm