Hi all, I have a bit of a dilema, I need to connect to an oracle database, but I can't use a TNSNames file. However when I asked for the connection info they gave me a tnsnames.ora file and told me to figure it out from there.
In the tnsnames file is a SID. However the software I am trying to use (SSIS) needs [host]:[port]\[service_name]. [host]:[port]\[sid] wont work and I can't find anything helpful through google on what I need to do to find the service_name. I know a couple of you are Oracle gurus, so I'm hoping you can help. Thanks, Steve ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:349928 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
