DevOps, CI/CD and Automation

This is rather embarrassing. I am pretty fluent with ASP and VBscript, and I have written many a web application connecting to Microsoft SQL Server. Now I have a need to connect to an Oracle database, and I'm beating my head against the wall.

1) Web server is Windows Server 2003 SP1

2) Using ASP (not ASP.NET) & VBscript

3) I have installed the Oracle drivers on the server - it is version 10g

4) The administrator of the Oracle database to which I want to connect has created a username and password for me to use from within my code

5) Here is the code I am trying to run:

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=MSDAORA;Data Source=XXXXXXX;User Id=YYYYYYY;Password=ZZZZZZZ;"

That's it. 2 lines of code just trying to establish a connection. Using the user name and password provided to me by the administrator, and for Data Source I am using the IP address of the Oracle server (like I have done in the past when connecting to SQL Server). I receive the following error message when viewing this in a browser:

Microsoft OLE DB Provider for Oracle error '80004005'

ORA-12154: TNS:could not resolve the connect identifier specified

Evidently, the Data Source I am using is not correct, but I was provided no other information from the admin. This is the first time any of us have tried to connect to Oracle using ASP/VBScript, so the administrator isn't sure what I need to do ... any help would be so appreciated.