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
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: CF Certified Print Logos?
.bin and .hqx are mac compressions like zip... ...if you deal with crossover files on a regular basis, try StuffIt by Alladin software...it will handle all sorts of formats for PC, Mac, and even Linux (i think it does tar...?)...there is a free version called UnStuffIt that just lets you extract (that's what i use)... ...but you probably already figured a way in judging from your last post... ...if you can extract it, the chances should be fairly good that you can pull the eps into Freehand (which comes with MX Studio) or Adobe Illustrator or Photoshop... good luck... ...dave pardon that notion. loooks like the print versions are only for mac. and the digital versions are standard .jpg and .gif format/extensions. sorry. tw On Tue, 12 Oct 2004 16:32:22 -0400, Tony Weeg [EMAIL PROTECTED] wrote: [Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]