Oracle.DataAccess.Client and .NET Framework errors in Microsoft Excel Announcing the arrival...
Why wasn't DOSKEY integrated with COMMAND.COM?
How to find all the available tools in mac terminal?
How do I make this wiring inside cabinet safer? (Pic)
If my PI received research grants from a company to be able to pay my postdoc salary, did I have a potential conflict interest too?
If a contract sometimes uses the wrong name, is it still valid?
For a new assistant professor in CS, how to build/manage a publication pipeline
Why are there no cargo aircraft with "flying wing" design?
Generate an RGB colour grid
Do I really need recursive chmod to restrict access to a folder?
Is it ethical to give a final exam after the professor has quit before teaching the remaining chapters of the course?
How to compare two different files line by line in unix?
Trademark violation for app?
Is there any way for the UK Prime Minister to make a motion directly dependent on Government confidence?
2001: A Space Odyssey's use of the song "Daisy Bell" (Bicycle Built for Two); life imitates art or vice-versa?
Is it a good idea to use CNN to classify 1D signal?
What is the meaning of the new sigil in Game of Thrones Season 8 intro?
Where are Serre’s lectures at Collège de France to be found?
An adverb for when you're not exaggerating
Would "destroying" Wurmcoil Engine prevent its tokens from being created?
Fantasy story; one type of magic grows in power with use, but the more powerful they are, they more they are drawn to travel to their source
When a candle burns, why does the top of wick glow if bottom of flame is hottest?
Is this homebrew Lady of Pain warlock patron balanced?
What is homebrew?
What causes the direction of lightning flashes?
Oracle.DataAccess.Client and .NET Framework errors in Microsoft Excel
Announcing the arrival of Valued Associate #679: Cesar Manara
Planned maintenance scheduled April 17/18, 2019 at 00:00UTC (8:00pm US/Eastern)How do I write a query in Microsoft SQL Server Management Studio and then use that Query in ExcelExcel Data Connection to Active DirectoryError installing/uninstalling GeoMedia WebMap Professional_6 on Windows 7 (64 bit)Installing .NET Framework 4 Client Profile breaks Windows UpdateConnect to PostgreSQL database from Excel 2013 Power Query with NpgsqlError on connecting excel to a oracle databaseRunning Parameterized Stored Proc From Power QueryWhat is the correct method to use data connections in Microsoft Excel?Cannot open MS Query from Excel 2016“Unable to enlist in the transaction” with Oracle linked server from MS SQL Server
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
When trying to access an Oracle 12c Database through Excel and Power Query, I received an error stating
The recommended provider("Oracle.DataAccess.Client") is not installed. You
can continue with your current provider, however it has been deprecated and
may not work correctly.
I went through Microsoft's own guide (https://support.office.com/en-us/article/connect-to-an-oracle-database-power-query-d7fbd231-a705-4eb7-83b3-a66bfb678395?ui=en-US&rs=en-US&ad=US) to install the ODAC. My specs are:
Windows 10 64-Bit
Excel for Office 365 MSO (16.0.11425.20200) 64-bit
Oracle 12c
So, following the microsoft guide, I installed
64-bit ODAC 12c Release 4 (12.1.0.2.4) Xcopy for Windows x64
(i've also tried releases 1 & 2 and the non-Xcopy versions of each, to no avail). The ODAC 12c Release 4 includes the following:
64-bit Oracle Data Provider for .NET 4 12.1.0.2.0
64-bit Oracle Data Provider for .NET 2.0 12.1.0.2.0
64-bit Oracle Providers for ASP.NET 4 12.1.0.2.0
64-bit Oracle Providers for ASP.NET 2.0 12.1.0.2.0
64-bit Oracle Provider for OLE DB 12.1.0.2.0
64-bit Oracle Services for Microsoft Transaction Server 12.1.0.2.0
64-bit Oracle Instant Client 12.1.0.2.0
When trying to connect to an Oracle database within Excel I get multiple errors:
First, I Click on
Data > Get Data > From Database > From Oracle Database
A messagebox/error appears stating
The recommended provider("Oracle.DataAccess.Client") is not installed. You
can continue with your current provider, however it has been deprecated and
may not work correctly.
I'm not sure why this message would appear, when I installed the Microsoft recommended ODAC. Nevertheless, I click
'OK'
An inputbox appears with title:
Oracle database
In the Server field I type:
%HOSTNAME%:%PORT%%SERVICE_NAME%
A new error message appears:
"Unable to Connect"
"We encountered an error while tyring to connect."
Details: "Failed to find or load the registered .Net Framework Data
Provider.. This is a configuration issue with the file
'C:WindowsMicrosoft.NETFramework64v4.0.30319Configmachine.config'."
At this point I am unable to continue and cannot connect to the Oracle database. Any and all insight would be greatly appreciated.
microsoft-excel .net-framework power-query oracle-12c
asked 15 hours ago
need_javaneed_java
63
add a comment |
When trying to access an Oracle 12c Database through Excel and Power Query, I received an error stating
The recommended provider("Oracle.DataAccess.Client") is not installed. You
can continue with your current provider, however it has been deprecated and
may not work correctly.
I went through Microsoft's own guide (https://support.office.com/en-us/article/connect-to-an-oracle-database-power-query-d7fbd231-a705-4eb7-83b3-a66bfb678395?ui=en-US&rs=en-US&ad=US) to install the ODAC. My specs are:
Windows 10 64-Bit
Excel for Office 365 MSO (16.0.11425.20200) 64-bit
Oracle 12c
So, following the microsoft guide, I installed
64-bit ODAC 12c Release 4 (12.1.0.2.4) Xcopy for Windows x64
(i've also tried releases 1 & 2 and the non-Xcopy versions of each, to no avail). The ODAC 12c Release 4 includes the following:
64-bit Oracle Data Provider for .NET 4 12.1.0.2.0
64-bit Oracle Data Provider for .NET 2.0 12.1.0.2.0
64-bit Oracle Providers for ASP.NET 4 12.1.0.2.0
64-bit Oracle Providers for ASP.NET 2.0 12.1.0.2.0
64-bit Oracle Provider for OLE DB 12.1.0.2.0
64-bit Oracle Services for Microsoft Transaction Server 12.1.0.2.0
64-bit Oracle Instant Client 12.1.0.2.0
When trying to connect to an Oracle database within Excel I get multiple errors:
First, I Click on
Data > Get Data > From Database > From Oracle Database
A messagebox/error appears stating
The recommended provider("Oracle.DataAccess.Client") is not installed. You
can continue with your current provider, however it has been deprecated and
may not work correctly.
I'm not sure why this message would appear, when I installed the Microsoft recommended ODAC. Nevertheless, I click
'OK'
An inputbox appears with title:
Oracle database
In the Server field I type:
%HOSTNAME%:%PORT%%SERVICE_NAME%
A new error message appears:
"Unable to Connect"
"We encountered an error while tyring to connect."
Details: "Failed to find or load the registered .Net Framework Data
Provider.. This is a configuration issue with the file
'C:WindowsMicrosoft.NETFramework64v4.0.30319Configmachine.config'."
At this point I am unable to continue and cannot connect to the Oracle database. Any and all insight would be greatly appreciated.
microsoft-excel .net-framework power-query oracle-12c
asked 15 hours ago
need_javaneed_java
63
add a comment |
When trying to access an Oracle 12c Database through Excel and Power Query, I received an error stating
The recommended provider("Oracle.DataAccess.Client") is not installed. You
can continue with your current provider, however it has been deprecated and
may not work correctly.
I went through Microsoft's own guide (https://support.office.com/en-us/article/connect-to-an-oracle-database-power-query-d7fbd231-a705-4eb7-83b3-a66bfb678395?ui=en-US&rs=en-US&ad=US) to install the ODAC. My specs are:
Windows 10 64-Bit
Excel for Office 365 MSO (16.0.11425.20200) 64-bit
Oracle 12c
So, following the microsoft guide, I installed
64-bit ODAC 12c Release 4 (12.1.0.2.4) Xcopy for Windows x64
(i've also tried releases 1 & 2 and the non-Xcopy versions of each, to no avail). The ODAC 12c Release 4 includes the following:
64-bit Oracle Data Provider for .NET 4 12.1.0.2.0
64-bit Oracle Data Provider for .NET 2.0 12.1.0.2.0
64-bit Oracle Providers for ASP.NET 4 12.1.0.2.0
64-bit Oracle Providers for ASP.NET 2.0 12.1.0.2.0
64-bit Oracle Provider for OLE DB 12.1.0.2.0
64-bit Oracle Services for Microsoft Transaction Server 12.1.0.2.0
64-bit Oracle Instant Client 12.1.0.2.0
When trying to connect to an Oracle database within Excel I get multiple errors:
First, I Click on
Data > Get Data > From Database > From Oracle Database
A messagebox/error appears stating
The recommended provider("Oracle.DataAccess.Client") is not installed. You
can continue with your current provider, however it has been deprecated and
may not work correctly.
I'm not sure why this message would appear, when I installed the Microsoft recommended ODAC. Nevertheless, I click
'OK'
An inputbox appears with title:
Oracle database
In the Server field I type:
%HOSTNAME%:%PORT%%SERVICE_NAME%
A new error message appears:
"Unable to Connect"
"We encountered an error while tyring to connect."
Details: "Failed to find or load the registered .Net Framework Data
Provider.. This is a configuration issue with the file
'C:WindowsMicrosoft.NETFramework64v4.0.30319Configmachine.config'."
At this point I am unable to continue and cannot connect to the Oracle database. Any and all insight would be greatly appreciated.
microsoft-excel .net-framework power-query oracle-12c
asked 15 hours ago
need_javaneed_java
63
When trying to access an Oracle 12c Database through Excel and Power Query, I received an error stating
The recommended provider("Oracle.DataAccess.Client") is not installed. You
can continue with your current provider, however it has been deprecated and
may not work correctly.
I went through Microsoft's own guide (https://support.office.com/en-us/article/connect-to-an-oracle-database-power-query-d7fbd231-a705-4eb7-83b3-a66bfb678395?ui=en-US&rs=en-US&ad=US) to install the ODAC. My specs are:
Windows 10 64-Bit
Excel for Office 365 MSO (16.0.11425.20200) 64-bit
Oracle 12c
So, following the microsoft guide, I installed
64-bit ODAC 12c Release 4 (12.1.0.2.4) Xcopy for Windows x64
(i've also tried releases 1 & 2 and the non-Xcopy versions of each, to no avail). The ODAC 12c Release 4 includes the following:
64-bit Oracle Data Provider for .NET 4 12.1.0.2.0
64-bit Oracle Data Provider for .NET 2.0 12.1.0.2.0
64-bit Oracle Providers for ASP.NET 4 12.1.0.2.0
64-bit Oracle Providers for ASP.NET 2.0 12.1.0.2.0
64-bit Oracle Provider for OLE DB 12.1.0.2.0
64-bit Oracle Services for Microsoft Transaction Server 12.1.0.2.0
64-bit Oracle Instant Client 12.1.0.2.0
When trying to connect to an Oracle database within Excel I get multiple errors:
First, I Click on
Data > Get Data > From Database > From Oracle Database
A messagebox/error appears stating
The recommended provider("Oracle.DataAccess.Client") is not installed. You
can continue with your current provider, however it has been deprecated and
may not work correctly.
I'm not sure why this message would appear, when I installed the Microsoft recommended ODAC. Nevertheless, I click
'OK'
An inputbox appears with title:
Oracle database
In the Server field I type:
%HOSTNAME%:%PORT%%SERVICE_NAME%
A new error message appears:
"Unable to Connect"
"We encountered an error while tyring to connect."
Details: "Failed to find or load the registered .Net Framework Data
Provider.. This is a configuration issue with the file
'C:WindowsMicrosoft.NETFramework64v4.0.30319Configmachine.config'."
At this point I am unable to continue and cannot connect to the Oracle database. Any and all insight would be greatly appreciated.
microsoft-excel .net-framework power-query oracle-12c
microsoft-excel .net-framework power-query oracle-12c
asked 15 hours ago
need_javaneed_java
63
asked 15 hours ago
need_javaneed_java
63
edited 14 hours ago
need_java
asked 15 hours ago
need_javaneed_java
63
asked 15 hours ago
need_javaneed_java
63
asked 15 hours ago
need_javaneed_java
63
63
add a comment |
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "3"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1426574%2foracle-dataaccess-client-and-net-framework-errors-in-microsoft-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Super User!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fsuperuser.com%2fquestions%2f1426574%2foracle-dataaccess-client-and-net-framework-errors-in-microsoft-excel%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
