My last email was incomplete SELECT * FROM yourtableinlinke...@nameofdblink
On Wed, Aug 4, 2010 at 8:25 PM, Qasim Rasheed <qasim.li...@gmail.com> wrote: > 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:336010 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm