Windows 10: CASE # 30643426 - SQL 2016 SSIS/SSRS not recognizing Oracle 19c 64 Bit Client

Discus and support CASE # 30643426 - SQL 2016 SSIS/SSRS not recognizing Oracle 19c 64 Bit Client in Windows 10 Software and Apps to solve the problem; We have opened a case with Microsoft, but are not getting any response on this. How do we get Microsoft to actually pay attention to a Support Ticket?... Discussion in 'Windows 10 Software and Apps' started by RichardCundiff, Apr 15, 2022.

  1. RICHARDCUNDIFF
    RichardCundiff Win User

    CASE # 30643426 - SQL 2016 SSIS/SSRS not recognizing Oracle 19c 64 Bit Client


    We have opened a case with Microsoft, but are not getting any response on this. How do we get Microsoft to actually pay attention to a Support Ticket? We have several SQL 2012 servers with SSIS/SSRS on them, using Oracle Clients for connecting to Oracle DBs. As 2012 is going out of support, we need to migrate these to SQL 2016 SSIS/SSRS. While we can get 2012 to properly reference and use the installed Oracle Clients 12.2 and 19c, SQL 2016 does not seem to even recognize that an Oracle Client is even installed on the server. We have installed the Oracle 19c 64 Bit Client on the server.

    :)
     
    RichardCundiff, Apr 15, 2022
    #1
  2. SHERRY SCHEFFE
    Sherry Scheffe Win User

    SSIS with Oracle connection doen't work in SQL job agent

    I use Oracle connection in SSIS. There are two ways to access Oracle data in SSIS package, one is MSORA Connector (Microsoft Connector for Oracle by Attunity), another is ODBC connection.

    I can use both ways when execute in visual studio. But it can’t be done in SQL server as step
    in job agent.

    Do you know what's the matter cause this issue? Thanks!
     
    Sherry Scheffe, Apr 15, 2022
    #2
  3. BRINK
    Brink Win User
    Migrate from Oracle to SQL Server 2016 with free licenses


    Read more: Microsoft waves the 'free licenses' flag to try to grab Oracle database users | ZDNet

    See also: Follow the leader and migrate from Oracle to SQL Server—with free licenses
     
    Brink, Apr 15, 2022
    #3
  4. RBRATTAS
    RBrattas Win User

    CASE # 30643426 - SQL 2016 SSIS/SSRS not recognizing Oracle 19c 64 Bit Client

    How do I Uninstall SQL Server 2016 (64-bit) in Windows 10 Apps & features

    Hi,

    How do I Uninstall SQL Server 2016 (64-bit) in Windows 10 Apps & Features when Modify and Uninstall button is displayed, but faded out and not accessible.

    I have managed to uninstall all related SQL programs, but I am stuck with SQL Server 2016 (64-bit) by using uninstall in Apps & features. And I am not able to see any SQL files in Programs and Features.

    I have deleted all Microsoft SQL servers folders manually in C:\Program Files and C:\Program Files (x86) after I have run the uninstall program, I have deleted all SQL files related to SQL in the Registry after the uninstall program
    did not clean the register file. And I have deleted all related SQL service files after the uninstall program left some files there, but still SQL Server 2016 (64-bit) shows up in Apps & features. I assume there are some SQL files I did not have to deleted.

    From where does the SQL Server 2016 (64-bit) in Apps & features comes from? I like to delete SQL Server 2016 (64-bit) from Apps & features, before I do a new SQL installation.

    Thanks,
     
    RBrattas, Apr 15, 2022
    #4
Thema:

CASE # 30643426 - SQL 2016 SSIS/SSRS not recognizing Oracle 19c 64 Bit Client

Loading...

  1. CASE # 30643426 - SQL 2016 SSIS/SSRS not recognizing Oracle 19c 64 Bit Client - Similar Threads - CASE 30643426 SQL

  2. SSRS 2019 not getting migrated from Sql 2016

    in Windows 10 Gaming
    SSRS 2019 not getting migrated from Sql 2016: Hi team,I am unable to migrated SSRS 2016 to SSRS 2019 getting below errorswhile restoring encryption key getting this error Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call...

  3. SSRS 2019 not getting migrated from Sql 2016

    in Windows 10 Software and Apps
    SSRS 2019 not getting migrated from Sql 2016: Hi team,I am unable to migrated SSRS 2016 to SSRS 2019 getting below errorswhile restoring encryption key getting this error Microsoft.ReportingServices.WmiProvider.WMIProviderException: An error occurred when attempting to connect to the report server remote procedure call...

  4. How To Solve error failed to create oracle Home user IN oracle 19c in windows 11?

    in Windows 10 Gaming
    How To Solve error failed to create oracle Home user IN oracle 19c in windows 11?: I have an issues with oracle 19c setupI got the error failed to create oracle Home user.i am using Windows 11 Home Single Language. https://answers.microsoft.com/en-us/windows/forum/all/how-to-solve-error-failed-to-create-oracle-home/873bd3eb-6e85-4229-ad07-d8597116cfd1

  5. CASE # 30643426 - SQL 2016 SSIS/SSRS not recognizing Oracle 19c 64 Bit Client

    in Windows 10 Gaming
    CASE # 30643426 - SQL 2016 SSIS/SSRS not recognizing Oracle 19c 64 Bit Client: We have opened a case with Microsoft, but are not getting any response on this. How do we get Microsoft to actually pay attention to a Support Ticket? We have several SQL 2012 servers with SSIS/SSRS on them, using Oracle Clients for connecting to Oracle DBs. As 2012 is going...

  6. SSIS with Oracle connection doen't work in SQL job agent

    in Windows 10 Drivers and Hardware
    SSIS with Oracle connection doen't work in SQL job agent: I use Oracle connection in SSIS. There are two ways to access Oracle data in SSIS package, one is MSORA Connector (Microsoft Connector for Oracle by Attunity), another is ODBC connection. I can use both ways when execute in visual studio. But it can’t be done in SQL server...

  7. How do I Uninstall SQL Server 2016 (64-bit) in Windows 10 Apps & features

    in Windows 10 Customization
    How do I Uninstall SQL Server 2016 (64-bit) in Windows 10 Apps & features: Hi, How do I Uninstall SQL Server 2016 (64-bit) in Windows 10 Apps & Features when Modify and Uninstall button is displayed, but faded out and not accessible. I have managed to uninstall all related SQL programs, but I am stuck with SQL Server 2016 (64-bit) by using...

  8. oracle virtual box won't show 64 bit options

    in Windows 10 Virtualization
    oracle virtual box won't show 64 bit options: Hi, I tried creating a kali linux 64-bit on my virtualbox, but it won't let me pick 64-bit options, only 32-bit and what I downloaded is 64 bit... I was told to shut down the hyper-v in windows features but turns out it was already off... any ideas?? thanks! 89413

  9. 64-bit architecture not recognized

    in Windows 10 Installation and Upgrade
    64-bit architecture not recognized: Hello, I recently upgraded my Windows 8.1 64-bit laptop to Windows 10 via a clean install. Windows 10 installed the 32-bit version, even though I downloaded the 64-bit version of the upgrade tool. I attempted to upgrade to the 64-bit version using the Windows Media...

  10. Migrate from Oracle to SQL Server 2016 with free licenses

    in Windows 10 News
    Migrate from Oracle to SQL Server 2016 with free licenses: Microsoft is trying to grab Oracle enterprise database users with a new migration offer for SQL Server 2016. Microsoft is starting to turn the crank on its SQL Server 2016 launch machine by going after Oracle database users with a migration offer. On March 10, the day...