none
SSDT Visual studio data tool 2015 Access Oracle DB through 32 driver

    Question

  • Hi I am creating an packages to connect to oracle and  output write to excel file. I am using SSDT 2015 version . On this task "OLD DB source" task I create a connection to oracle database using 32 bit driver(ODTwithODAC121010). connection has tested and working. But when I place just simple sql on "OLE DB Source" and click "preview" I am getting following error

    The system cannot find message text for message number 0x80040e51 in the message file for OraOLEDB.
    (OraOLEDB)

    Note: I configure 32 bit ODBC driver to connect to the Oracle DB and its connecting.  Not sure why "preview" get error. any one seen this before


    • Edited by ashwan Tuesday, December 4, 2018 11:01 PM
    Tuesday, December 4, 2018 10:59 PM

Answers

  • Hi ashwan, 

    It's a known issue in SSDT2017/2015, as a workaround, you can use ADO.Net Connection and OracleClient Data Provider. 

    Please check the discussion in this thread: 

    Unable to Preview Oracle OLE DB Source in SSDT 17.2/VS2015


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by ashwan Thursday, December 6, 2018 11:05 PM
    Wednesday, December 5, 2018 2:25 AM
  • Hi I installed "SQL Server Data Tools for Visual Studio 2013"  and its works. I think do not use 2015 SSDT to connect  oracle its a buggy and ate my time.

    thanks'

    • Marked as answer by ashwan Thursday, December 6, 2018 11:04 PM
    Thursday, December 6, 2018 11:04 PM

All replies

  • Hi ashwan, 

    It's a known issue in SSDT2017/2015, as a workaround, you can use ADO.Net Connection and OracleClient Data Provider. 

    Please check the discussion in this thread: 

    Unable to Preview Oracle OLE DB Source in SSDT 17.2/VS2015


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    • Marked as answer by ashwan Thursday, December 6, 2018 11:05 PM
    Wednesday, December 5, 2018 2:25 AM
  • Hi I installed "SQL Server Data Tools for Visual Studio 2013"  and its works. I think do not use 2015 SSDT to connect  oracle its a buggy and ate my time.

    thanks'

    • Marked as answer by ashwan Thursday, December 6, 2018 11:04 PM
    Thursday, December 6, 2018 11:04 PM