I have a really basic question here. How do I install drivers for "Microsoft OLEDB provider for Oracle" so that connection starts working in BIDS?
I've found this link so far and it says "Make sure the Oracle client software on the server running SQL Server is at the level required by the provider." Does it mean that the only
way to install drivers on my development machine is to install an Oracle client?
Normally it should be installed with the set-up of SQL Server or the OS, if I'm not mistaken.
But there is no 64-bit version and according to this already very old article, this provider is deprecated.