Forum Stats

  • 3,767,820 Users
  • 2,252,720 Discussions
  • 7,874,337 Comments

Discussions

which ODAC for VisualStudio 2019 (workstation on Windows 7) and MSSQL 2019 (on Windows 2019 server)

Hello.

I have VisualStudio 2019 (workstation on Windows 7) and MSSQL 2019 (on Windows 2019 server).

I must connect to Oracle 10.2 and Oracle 12c from dtsx packages.

Which ODAC should I install ?

ODAC 19c or ODAC 12c ?

Does ODAC 19c work on Windows 7 ?

Does ODAC 12c work with VisualStudio 2019 ?

Answers

  • Alex Keh-Oracle
    Alex Keh-Oracle Posts: 2,968 Employee
    edited Apr 14, 2020 5:21PM

    ODAC 11.2 has drivers that can connect to both 10g and 12c DB server versions. Officially, Oracle 10.2 is no longer supported.

    Windows 7 reached Microsoft end of life at the beginning of this year, which ends all Oracle support for Windows 7 as well.

    Oracle DB drivers can all work in VS 2019 as long as the runtime version (e.g. .NET 4.7.2) is available in the IDE/OS. The drivers do not rely on the IDE version to work.

    Here's a tutorial using SSIS with Oracle Autonomous DB (Cloud): https://www.oracle.com/a/ocom/docs/database/ssis-to-adb.pdf

    Conceptually, connectivity setup is similar (and likely simpler) to an on-premises Oracle DB.