RE: Microsoft Oracle OLE DB Provider

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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:

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/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@xxxxxxxxxxxxxx
===========================================================
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 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/subscriptions/aa948874.aspx.
============================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
=========================================================



.

Relevant Pages

  • RE: Sql Server 2005 Setup will not run
    ... Thank you for using Microsoft MSDN Managed Newsgroup. ... Is there any SQL Server instance installed on the machine? ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.tools)
  • RE: automating running a stored procedure
    ... Thank you for using Microsoft MSDN Managed Newsgroup. ... If you use SQL Server express edition, since the SQL Agent Service is not ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.dts)
  • RE: Alias best way in SQL Server
    ... Thank you for using Microsoft MSDN Managed Newsgroup. ... application connect to the SQL Server? ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.server)
  • RE: Invalid Reference Error
    ... Welcome to Microsoft MSDN Managed Newsgroup. ... An MDE file is the same as a regular Access MDB database file, ... Microsoft Online Community Support ...
    (microsoft.public.access.forms)
  • RE: Cannot telnet to server from LAN
    ... Thank you for using Microsoft MSDN Managed Newsgroup. ... we could get the port number of the sql instance by SQL Server ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)