Hello Fellow Earthlings
I'm a bit new when it comes to creating Oracle drivers and I was the lucky winner assigned to make an oracle driver.
My driver works but, the connection string that the driver creates bypasses TNSnames, meaning its a bit of a manual string creation.
Currently my driver only replaces the SID variable and does not cater for Service_Names.
I know that Service Names are used in Cluster's and SID is a unique DB name usually, but beyond this is know nothing more.
Questions:
What is the difference between a Service Name and SID in the TNSnames? (technical answer if possible)
Can I use both in the TNSnames?
Kind Regards and thanks in advance.