I am trying to connect to my Oracle DB using ODP.NET Managed Driver.
I have the following information available to me:
- Username
- Password
- Host Name
- Port Number
- SID
I would like to be able to connect using the EZ Connect connection type. I would think that would make my life easier for when I deploy to different servers.
How can I make this connection? I get an error when I substitute the SID for the service name.