6/21/2023 0 Comments No valid oracle clients found toadThis all worked for me and hope it helps you as well. You need to have a TNS_ADMIN entry in the Environment Variables that points to the directory that the tns_names.ora file lives. You also need to make sure the following is included in the 'path' of the Environment Variables:Ĭ:\app\Oracle\product\12.2.0\client_1 C:\app\Oracle\product\12.2.0\client_1\bin (or wherever your path is loacted) Install all C:\app\Oracle\product\12.2.0\client_1 odac (the path is where you installed the above client to) To install the above you must open a Administator Command Prompt and change to the path that you extracted the files to. Note: in my case I change the default path of the install to C:\app\Oracle\product\12.2.0\client_1 but it doesn't matter where you put it.Īfter installing the client I had to install the following: (IT WILL NOT WORK WITHOUT THIS!) In my case I installed the following Oracle Client on my respective installs: This has been happening since I upgraded the Oracle Client to Oracle 12c from 11g. It's the same install on each except you must use the matching bit version of the Oracle products that matches the PowerBI Desktop bit version. You need at least one 64-bit client properly configured. after installing 32-bit Oracle client software on a 64-bit Windows. For my experience, I installed on a 32-bit system and one on a 64-bit system. There is no control over this path name at install time because the SQL Server.
0 Comments
Leave a Reply. |