As someone already indicated, why do you want to run db link command from CF. It should be just a one time thing that your DBA can run. Later you can run query against a table in linked database like this
SELECT * FROM On Wed, Aug 4, 2010 at 9:58 AM, Won Lee <won...@gmail.com> wrote: > > 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:336009 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm