Forum Discussion

tjukken's avatar
tjukken
Advocate II
8 years ago

Oracle connection error: Object reference not set to an instance

Hi   I'm trying to connect to an Oracle 11g database (not local), but I do only receive an error message. First I write in the servername/ip-address/tnsnames on the Oracle server and then I'm displ...
Need Help
thymallus's avatar
thymallus
Frequent Visitor
8 years ago

 Hi Andy,

 

Did you manage to solve this issue?

 

Likewise, I'm also trying to connect to an Oracle 11g database with drivers from the 64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64 (ODAC122010_x64.zip) and I'm getting the same "An error happened while reading data from the provider: 'Object reference not set to an instance of an object.'" error. This happens in Power BI Desktop (Februrary 2018 64-bit) as well as when trying to setup a new data source for on-premises data gateway. I do have tnsnames.ora defined and the connection defined there works fine with SQLPlus. As for Power BI, both tnsnames.ora and IP/SID produce the same error.

 

Using the 32-bit version of Power BI desktop and 32-bit drivers from ODAC 12.2c Release 1 and Oracle Developer Tools for Visual Studio all is working well. The problem is, I really do need the 64-bit drivers for the on-premises data gateway.

 

 

  • tjukken's avatar
    tjukken
    Advocate II
    8 years ago

    No, I didn't proceed with the issue in this case. We created a (poor) workaround with CSV-files.

     

    Good luck. :)

    • thymallus's avatar
      thymallus
      Frequent Visitor
      8 years ago

      Ok, thanks. I created a support ticket now, I'll keep you posted.

      • tjukken's avatar
        tjukken
        Advocate II
        8 years ago

        That would be great!