Data Source

[#1]

I am connecting to an Oracle database instance and when I go to create the connection in the wizard by:

1. Selecting edit script

2. Selecting ODLE DB then Connect

3. Selecting Oracle Provider for OLE DB

4. On the connection Tab I do not know the value to put in for the prompt requesting me to

"Enter the data source and/or location of the data

Data Source: ??? I don't know what to put here and the video doesn't explain it

5. The part that says "Enter information to log on to the server:

I select "Use a specific user name and password" then I enter the correct information.

The test connection tab comes back as pass but it is not connecting me to a specific database. What do I do?

[#2]

Sorry John. Was super busy yesterday. Let me take a look at it a little later today and I will respond back tomorrow. Thank you for your time and your quick response.

[#3]

Nope. Same error. It's official. Networking sucks lol... I have no idea how to get around this. This should be such an easy step.