DevOps, CI/CD and Automation

First off I'm completely new to using Oracle inside .Net so the errors I've been receiving are completely lost on me and the research I've done on the web over the past couple of days has not returned anything useful. Secondly I have verified that the Oracle database is up and running and I can ping the server from the machine I am running this code so there is a clear line of sight. Third, I am using Oracle 8.1 to try to accomplish this task.

Here's a look at my code....
Dim oledb As New OleDb.OleDbConnection("Provider=OraOLEDB.Oracle;Data Source=BSA;User Id=****;Password=****;")
oledb.Open()

Now, the error for this code... (which occurs when I try to open the connection)
ORA-12514: TNS:listener cound not resolve SERVICE_NAME given in connect descriptor at.......

Here's the other version of the code with the only difference being the Provider...
Dim oledb As New OleDb.OleDbConnection("Provider=msdaora.1;Data Source=BSA;User Id=****;Password=****;")
oledb.Open()

Now, the error for this code... (which occurs when I try to open the connection)
System.Data.OleDb.OleDbException: Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.

Ok, my assumptions at this point are that I should be using the OraOLEDB provider like I am in the first scenario. Which leads me to wondering how to resolve the SERVICE_NAME problem the error talks about. I've read some posts about updating a listeners.ora (?) file but haven't seen a good description on how to do that or what to even put in it so I'm weary of doing so. Can anyone give me a push in the right direction? Thx.