How to add linked Oracle server to SQL 2008 Express?
- by David.Chu.ca
I have tried to download Oracle Client 11g both 32 & 64 packages to Windows 2008 R2 with SQL server 2008 Express. However, I still cannot see Oracle provider in SQL server by using sa log in. Not sure if is it possible to do it for SQL Server express 2008? Any advice to do it?
I followed installations from this article: Making Linked Server Connection Between SQL Server 64 Bit & Oracle 32 Bit | MS SQL World
After installation and reboot the Windows, I still cannot see the Oracle provider in linked provider in SQL server.