Final solution that seemed to work:
Ok, the quick rundown
Fixed the ldap references In the code
Replaced the username and passwords for accounts in our domain (Remember
this code came from a separate company)
Installed Oracle Client software on Server
Installed Oracle OLE DB connectivity software (ODAC) from Oracle’s website.
This seemed to resolve the error I got in regards to the Oracle Client not
being found
Finally, the account used to access the database did not have the right to
view specific tables. It could see the list of tables, but not specific
tables.
My DBA had to create synonyms for the account used to access the database to
mimic the account that had ownership of the tables in the database.
At this point, I can now connect, perform queries on the tables, etc ,etc..
Wallah, thanks for the journey,
Thanks for all of your help