Re: Microsoft Oracle OLE DB Provider
- From: "wpher56" <wpher56@xxxxxxxxx>
- Date: Mon, 23 Feb 2009 14:02:50 +0100
I understand that you would like to connect to your Oracle 9 and 10 from
your 64-bit SQL Server 2008 instance via linked server, however you found
that MSDAORA does not include a 64-bit OLE DB provider.
If I have misunderstood, please let me know.
Yes, MSDAORA is old and designed for Oracle 8. Currently Microsoft does not
provide any 64-bit provider for Oracle. You need to get Oracle's 64-bit
OLEDB Provider for Oracle from Oracle's website. Here is the link for your
reference:
http://www.oracle.com/technology/software/tech/windows/odpnet/64-bit/index.html
I have the same problem. Also I downloaded the x64 version and tried to install it on my Windows Server 2008 x64 machine. The setup starts, but stops after some seconds with the error "Java(TM)2 Platform Standard Edition binary has stopped working":
Problem signature:
Problem Event Name: APPCRASH
Application Name: javaw.exe
Application Version: 5.0.40.5
Application Timestamp: 42a019e4
Fault Module Name: StackHash_5c81
Fault Module Version: 6.0.6001.18000
Fault Module Timestamp: 4791adec
Exception Code: c0000374
Exception Offset: 00000000000a6e97
OS Version: 6.0.6001.2.1.0.274.10
Locale ID: 4108
Additional Information 1: 5c81
Additional Information 2: fa1981fc0da3377cbbec45e762388188
Additional Information 3: 7698
Additional Information 4: 7defb6f15001721d919a359fb7888c17
I have 3 javaw.exe in c:\program files(x86)\EMC\Navisphere subdirectories, but none is executable without being in its subdirectory, which is not in the PATH variable.
Any hint to help me would be welcome
Pierrot
.
- Prev by Date: RE: Unable to edit data in table in Management Studio 2005
- Next by Date: Re: Unable to edit data in table in Management Studio 2005
- Previous by thread: SQL server connectivity
- Next by thread: RE: Microsoft Oracle OLE DB Provider
- Index(es):
Relevant Pages
|
