I configured linked server using "Oracle Provider for OLE DB" and tested connection. Everything works fine. When I execute insert command, the problem arises.
Windows 7 Ultimate 64 bit
SQL Server 2008 R2 Standard Edition 64 bit
Oracle 11gR2 Client 64 bit
ODAC 220.127.116.11.2.0 64 bit
I think Microsoft OLE DB provider for Oracle will work. But I can't get that option while configuring linked server. So I need to install Microsoft OLE DB provider for Oracle.
Please anyone help.