Re: oracle database link
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
Re: oracle database link
Qasim, what's up? How's the Triangle? I get it now. I didn't realize the connection was session independent. I have noticed that i can let the link persist across sessions from my PL/SQL client...I didn't realize that was the case when I first wrote this question. But it has to be run FROM the cf server...hmmm. This would all be SOOO much easier if I were admin on that box. *sigh* Thanks! Dave P 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, W ~| 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:336051 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: oracle database link
We do this all the time with one of our government clients. Unfortunately I have no good idea as to how it was setup (their DBAs handle that part). What I can say is 1) When we have cross-schema joins it is done using proper FKs setup between the schemas 2) permissions involve SELECT and REFERENCES 3) in our case the schemas are on the SAME server Cheers Bryan Stevenson B.Comm. VP Director of E-Commerce Development Electric Edge Systems Group Inc. phone: 250.480.0642 fax: 250.480.1264 cell: 250.920.8830 e-mail: br...@electricedgesystems.com web: www.electricedgesystems.com Notice: This message, including any attachments, is confidential and may contain information that is privileged or exempt from disclosure. It is intended only for the person to whom it is addressed unless expressly authorized otherwise by the sender. If you are not an authorized recipient, please notify the sender immediately and permanently destroy all copies of this message and attachments. Please consider the environment before printing this e-mail ~| 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:336052 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: oracle database link
Can't you just get the DBA to create the dblink? -- WSS4CF - WS-Security framework for CF http://wss4cf.riaforge.org/ On 6 August 2010 03:23, Dave P jda...@gmail.com wrote: Qasim, what's up? How's the Triangle? I get it now. I didn't realize the connection was session independent. I have noticed that i can let the link persist across sessions from my PL/SQL client...I didn't realize that was the case when I first wrote this question. But it has to be run FROM the cf server...hmmm. This would all be SOOO much easier if I were admin on that box. *s ~| 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:336055 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
oracle database link
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
RE: oracle database link
Dave, The error suggests something coming back from the first Oracle server. I would start by searching the oracle docs for that message. -Mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -Original Message- From: Dave P [mailto:jda...@gmail.com] Sent: Wednesday, August 04, 2010 8:12 AM To: cf-talk Subject: oracle database link 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:335975 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
Re: oracle database link
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
Re: oracle database link
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
Re: oracle database link
My last email was incomplete SELECT * FROMyourtableinlinke...@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