none
Not able to see ODBC 64bit drivers in SSIS connection manager drop-down list. RRS feed

  • Question

  • I am not able to see ODBC 64bit drivers in SSIS connection manager drop-down list? only 32bit drivers are appearing in Visual Studio 2017 SSIS project. Any solution to see list of available DSN 64bit ODBC drivers?
    Thursday, May 21, 2020 3:45 PM

All replies

  • Hi kprasadvv,

    1.Search for or browse to the ODBC Data Sources (64-bit) applet in the Start Menu or Control Panel. If you only have a 32-bit driver, or you know that you have to use a 32-bit driver, search for or browse to ODBC Data Sources (32-bit) instead.
    2.Launch the applet. The ODBC Data Source Administrator window opens.
    3.On the Drivers tab, you can find a list of all the ODBC drivers installed on your computer. (The names of some of the drivers may be listed in multiple languages.)

    Please refer to Make sure the ODBC driver you want is installed and Create an ODBC Connection.

    Best Regards,

    Mona


    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

    Friday, May 22, 2020 1:53 AM
  • only 32bit drivers are appearing in Visual Studio 2017 SSIS project.

    It's because Visual Studio is a 32 bit application; you have to install 32 bit ODBC provider, too.


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Friday, May 22, 2020 7:34 AM
  • Then how can I test connectivity when adding Oracle ODBC in connection managers in SSIS? Oracle does not allow any connections from 32bit ODBC driver connections.
    Friday, May 22, 2020 6:59 PM
  • Hi kprasadvv,

    What is your SSIS version?

    If you targeting SSIS 2019, you can use 

    Microsoft Connector for Oracle.
    It doesn't even require Oracle Client installation !!!

    The earlier versions of the Connector support SSIS 2017 and earlier versions.

    Check it out the following links:

    • https://docs.microsoft.com/en-us/sql/integration-services/data-flow/oracle-connector?view=sql-server-ver15
    • https://techcommunity.microsoft.com/t5/sql-server-integration-services/microsoft-connector-for-oracle-is-released-for-sql-server-2019/ba-p/565923#
    Friday, May 22, 2020 7:19 PM
  • Oracle does not allow any connections from 32bit ODBC driver connections.
    It do, I used it several time and Oracle DB engine isn't aware which architecture 32/64 bit the client app is.

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Saturday, May 23, 2020 3:53 AM