When trying to add a new Linked Server in SSMS 2019 for one of my OracleDBs hosted on a VM I receive the:
53: Login Timeout Expired if choosing the 'Microsoft OLE DB Driver for SQL Server' Provider
Or the 7302: Cannot create an instance of the OLE DB Provider if choosing the 'Oracle Provider for OLE DB' Provider.
The ODBC itself is a 64-bit connection using the: Oracle in OraClient12Home1 Driver
Which tests successfully.
If I were to go into Excel for example and choose this Data source it's able to connect to the DB without an issue and display all of my tables and pull the information down from them it's just within SSMS.
Allow In provider for both providers has also been ticked.
Any help would be appreciated!