Hi, Going forward our product would support on SQL Server 2008(both 32 bit and 64 bit).We do migrate data in our application from Oarcle to SQL Server using LINKED Server using provider is 'MSDAORA'.We never ever had any issue in migration for
any SQL Server versions. but for migration data from Oracle 11G 64-bit to SQL Server 2008 64 bit we are facing issue says 'The OLE DB provider "MSDAORA" has not registered'.
I pulled this from a Microsoft forum:
“MSDAORA is old and designed for Oracle 8. Currently Microsoft does not provide any 64-bit provider for Oracle.”
Please let me know how to resolve this issue.
View Complete Post