![]() The Oracle client software you use depends on the Oracle server version, but will always match the 64-bit gateway. To connect to an Oracle database with the on-premises data gateway, the correct Oracle client software must be installed on the computer running the gateway. Make sure that checkbox is selected so that Power Query can connect to your Oracle database. Some versions of the Oracle client wizard selects the checkbox by default, others do'nt. ![]() During the setup of the Oracle client, make sure you enable Configure ODP.NET and/or Oracle Providers for ASP.NET at machine-wide level by selecting the corresponding checkbox during the setup wizard. Choose the Windows installer of the Oracle Client. For instance, ODAC 12.x doesn't always support Oracle Server version 9. ![]() Choose a version of Oracle Data Access Client (ODAC) that's compatible with your Oracle Server.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |