Won, Yes, schema to schema.
I'm attempting a join across databases. These databases used to be on the same server with different owners. They just moved our app to another server, and now I have to use a DB link to get the same join to work. The outcome of these queries is an internal reporting dashboard. Which is better than pulling this data manually every week, no matter how hard it is to set up to begin with. ;o) Thanks, Dave P >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? > > > > > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:336050 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm