I've just set up SQL 2008 Enterprise x64 on a win 2008 x64 enterprise server
os.

In creating some linked server connections, i see that no MSDAORA provider
exists in the x64 version.

Do i need to load some other component to get that OLE DB provider? We need
to be able to connect to Oracle 9 and 10 backend databases running under Unix.

thanks

Hi Frosty,
Thank you for using Microsoft MSDN Managed Newsgroup.

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/sof...64-bit/index.h
tml

Hope this helps. If you have any other questions or concerns, please feel
free to let me know.

Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 2 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions. Issues of this
nature are best handled working with a dedicated Microsoft Support Engineer
by contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/en-us/subs.../aa948874.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======

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

Charles,

I tried following the link that you provided but I got an error. Could you
check the link and repost please?

"We're sorry, the page you requested was not found.

We have recorded this error (404) to help us fix the problem.
You may wish to try again using one of the tools below. "

Thanks!
--
Aaron Nelson.


""Charles Wang [MSFT]"" wrote:

http://www.oracle.com/technology/sof.../index.htmlThe last 3 characters ("tml") were split on the second linePierrot"Aaron Nelson" <AaronNelson (AT) discussions (DOT) microsoft.com> wrote in messagenews:95C5366A-18E3-492E-9294-20102D9465C2 (AT) microsoft (DOT) com...> Charles,>> I tried following the link that you provided but I got an error. Couldyou> check the link and repost please?>> "We're sorry, the page you requested was not found.>> We have recorded this error (404) to help us fix the problem.> You may wish to try again using one of the tools below. ">> Thanks!> --> Aaron Nelson.>>> ""Charles Wang [MSFT]"" wrote:>>> Hi Frosty,>> Thank you for using Microsoft MSDN Managed Newsgroup.>>>> 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 youfound>> 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 doesnot>> 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 foryour>> reference:>>http://www.oracle.com/technology/software/tech/windows/odpnet/64-bit/index.h>> tml>>>> Hope this helps. If you have any other questions or concerns, please feel>> free to let me know.>>>> Best regards,>> Charles Wang>> Microsoft Online Community Support>> ================================================== =========>> Delighting our customers is our #1 priority. We welcome your>> comments and suggestions about how we can improve the>> support we provide to you. Please feel free to let my manager>> know what you think of the level of service provided. You can>> send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.>> ================================================== =========>> Get notification to my posts through email? Please refer to>>http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif>> ications.>>>> Note: MSDN Managed Newsgroup support offering is for non-urgent issues>> where an initial response from the community or a Microsoft Support>> Engineer within 2 business day is acceptable. Please note that eachfollow>> up response may take approximately 2 business days as the support>> professional working with you may need further investigation to reach the>> most efficient resolution. The offering is not appropriate for situations>> that require urgent, real-time or phone-based interactions. Issues ofthis>> nature are best handled working with a dedicated Microsoft SupportEngineer>> by contacting Microsoft Customer Support Services (CSS) at>> http://msdn.microsoft.com/en-us/subscriptions/aa948874.aspx.>> ================================================== ==========>> This posting is provided "AS IS" with no warranties, and confers norights.>> ================================================== =======>>>>>>

Ooops, sorry for the formatting of my previous reply, something went wrong.
This is the link:

http://www.oracle.com/technology/sof...bit/index.html

The last 3 characters ("tml") were split on the second line.

Pierrot


"Aaron Nelson" <AaronNelson (AT) discussions (DOT) microsoft.com> wrote

Previous link does not install on Win 7 x64...I installed 10g 64 bit ODAC
from link below and it won't install - running setup as admin and results in
"Java 2 Platform Standard Edition binary has stopped working.

I installed 11g 64 bit ODAC and along with Attunity driver BIDS picks up
OleDB driver just fine. I just can't get linked servers to detect any Oracle
providers.


"wpher56" wrote: