I assume you mean a link from one oracle schema to another schema by executing the CREATE DATABASE LINK sql command through a CFML page.
Is this correct? If it is check your permissions. This most likely has nothing to do with CF. As I side note, I don't think CFML pages should be running this sort of code. You should just login to your Oracle DB and run that command to create a link. Curious? Is there a reason why you just don't create a new CF datasource in the CF ADMIN? On Wed, Aug 4, 2010 at 9:11 AM, Dave P <jda...@gmail.com> wrote: > > 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:335976 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm