Beantwortet Configure Microsoft OLEDB provider for Oracle.

  • martes, 24 de abril de 2012 8:30
     
     

    Hello,

    I have a really basic question here. How do I install drivers for "Microsoft OLEDB provider for Oracle" so that connection starts working in BIDS?

    I've found this link so far and it says "Make sure the Oracle client software on the server running SQL Server is at the level required by the provider." Does it mean that the only way to install drivers on my development machine is to install an Oracle client?

    Thanks!

Todas las respuestas

  • martes, 24 de abril de 2012 8:39
     
     Respondida

    Normally it should be installed with the set-up of SQL Server or the OS, if I'm not mistaken.
    But there is no 64-bit version and according to this already very old article, this provider is deprecated.

    http://msdn.microsoft.com/en-us/library/ms810810.aspx

    If you install the Oracle client, you'll get the Oracle OLE DB provider, which is also available in 64-bit.


    MCTS, MCITP - Please mark posts as answered where appropriate.