Skip to main content
The 2024 Developer Survey results are live! See the results
added environment variables
Source Link
neydroydrec
  • 223
  • 2
  • 4
  • 14

I'm trying to import data from Oracle to Excel. I was hoping to find Oracle DB on the drop down under Get Data as see online:

enter image description here

That picture not being there I hit the documentation explaining I should install 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio (12.1.0.2.4).

After doing this, I could not see the drop down. However, I read elsewhere that it could be accessed from the Other Sources > From OBDC:

enter image description here

I went through my Windows Admin Tools > ODBC Data Source Administrator and there I added a new Microsoft ODBC for Oracle Setup.

My database now appeared in the ODBC database choice drop down. I call for the query and... I get two errors:

First a Windows error:

"The Oracle(tm) client and networking components were not found. Thesec components are supplied by Oracle Corportation and are part of the Oracle Version 7.3 (or greater) client software installation. You will be unable to use these drivers until these components have been installed"

Then power query error:

"ODBC: ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

Update: When running Excel as an Administrator, I am only getting the second error message.

I've looked up my environment variables, as I've seen elsewhere that they may be related to this issue:

enter image description here

So now I'm a litte confused and don't understand what this means and what I've done wrong. Other posts here didn't point to the right direction (I think).

I'm trying to import data from Oracle to Excel. I was hoping to find Oracle DB on the drop down under Get Data as see online:

enter image description here

That picture not being there I hit the documentation explaining I should install 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio (12.1.0.2.4).

After doing this, I could not see the drop down. However, I read elsewhere that it could be accessed from the Other Sources > From OBDC:

enter image description here

I went through my Windows Admin Tools > ODBC Data Source Administrator and there I added a new Microsoft ODBC for Oracle Setup.

My database now appeared in the ODBC database choice drop down. I call for the query and... I get two errors:

First a Windows error:

"The Oracle(tm) client and networking components were not found. Thesec components are supplied by Oracle Corportation and are part of the Oracle Version 7.3 (or greater) client software installation. You will be unable to use these drivers until these components have been installed"

Then power query error:

"ODBC: ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

Update: When running Excel as an Administrator, I am only getting the second error message.

So now I'm a litte confused and don't understand what this means and what I've done wrong. Other posts here didn't point to the right direction (I think).

I'm trying to import data from Oracle to Excel. I was hoping to find Oracle DB on the drop down under Get Data as see online:

enter image description here

That picture not being there I hit the documentation explaining I should install 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio (12.1.0.2.4).

After doing this, I could not see the drop down. However, I read elsewhere that it could be accessed from the Other Sources > From OBDC:

enter image description here

I went through my Windows Admin Tools > ODBC Data Source Administrator and there I added a new Microsoft ODBC for Oracle Setup.

My database now appeared in the ODBC database choice drop down. I call for the query and... I get two errors:

First a Windows error:

"The Oracle(tm) client and networking components were not found. Thesec components are supplied by Oracle Corportation and are part of the Oracle Version 7.3 (or greater) client software installation. You will be unable to use these drivers until these components have been installed"

Then power query error:

"ODBC: ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

Update: When running Excel as an Administrator, I am only getting the second error message.

I've looked up my environment variables, as I've seen elsewhere that they may be related to this issue:

enter image description here

So now I'm a litte confused and don't understand what this means and what I've done wrong. Other posts here didn't point to the right direction (I think).

added 101 characters in body
Source Link
neydroydrec
  • 223
  • 2
  • 4
  • 14

I'm trying to import data from Oracle to Excel. I was hoping to find Oracle DB on the drop down under Get Data as see online:

enter image description here

That picture not being there I hit the documentation explaining I should install 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio (12.1.0.2.4).

After doing this, I could not see the drop down. However, I read elsewhere that it could be accessed from the Other Sources > From OBDC:

enter image description here

I went through my Windows Admin Tools > ODBC Data Source Administrator and there I added a new Microsoft ODBC for Oracle Setup.

My database now appeared in the ODBC database choice drop down. I call for the query and... I get two errors:

First a Windows error:

"The Oracle(tm) client and networking components were not found. Thesec components are supplied by Oracle Corportation and are part of the Oracle Version 7.3 (or greater) client software installation. You will be unable to use these drivers until these components have been installed"

Then power query error:

"ODBC: ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

Update: When running Excel as an Administrator, I am only getting the second error message.

So now I'm a litte confused and don't understand what this means and what I've done wrong. Other posts here didn't point to the right direction (I think).

I'm trying to import data from Oracle to Excel. I was hoping to find Oracle DB on the drop down under Get Data as see online:

enter image description here

That picture not being there I hit the documentation explaining I should install 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio (12.1.0.2.4).

After doing this, I could not see the drop down. However, I read elsewhere that it could be accessed from the Other Sources > From OBDC:

enter image description here

I went through my Windows Admin Tools > ODBC Data Source Administrator and there I added a new Microsoft ODBC for Oracle Setup.

My database now appeared in the ODBC database choice drop down. I call for the query and... I get two errors:

First a Windows error:

"The Oracle(tm) client and networking components were not found. Thesec components are supplied by Oracle Corportation and are part of the Oracle Version 7.3 (or greater) client software installation. You will be unable to use these drivers until these components have been installed"

Then power query error:

"ODBC: ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

So now I'm a litte confused and don't understand what this means and what I've done wrong. Other posts here didn't point to the right direction (I think).

I'm trying to import data from Oracle to Excel. I was hoping to find Oracle DB on the drop down under Get Data as see online:

enter image description here

That picture not being there I hit the documentation explaining I should install 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio (12.1.0.2.4).

After doing this, I could not see the drop down. However, I read elsewhere that it could be accessed from the Other Sources > From OBDC:

enter image description here

I went through my Windows Admin Tools > ODBC Data Source Administrator and there I added a new Microsoft ODBC for Oracle Setup.

My database now appeared in the ODBC database choice drop down. I call for the query and... I get two errors:

First a Windows error:

"The Oracle(tm) client and networking components were not found. Thesec components are supplied by Oracle Corportation and are part of the Oracle Version 7.3 (or greater) client software installation. You will be unable to use these drivers until these components have been installed"

Then power query error:

"ODBC: ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

Update: When running Excel as an Administrator, I am only getting the second error message.

So now I'm a litte confused and don't understand what this means and what I've done wrong. Other posts here didn't point to the right direction (I think).

Source Link
neydroydrec
  • 223
  • 2
  • 4
  • 14

Cannot connect to Oracle Database with Power Query

I'm trying to import data from Oracle to Excel. I was hoping to find Oracle DB on the drop down under Get Data as see online:

enter image description here

That picture not being there I hit the documentation explaining I should install 32-bit Oracle Data Access Components (ODAC) with Oracle Developer Tools for Visual Studio (12.1.0.2.4).

After doing this, I could not see the drop down. However, I read elsewhere that it could be accessed from the Other Sources > From OBDC:

enter image description here

I went through my Windows Admin Tools > ODBC Data Source Administrator and there I added a new Microsoft ODBC for Oracle Setup.

My database now appeared in the ODBC database choice drop down. I call for the query and... I get two errors:

First a Windows error:

"The Oracle(tm) client and networking components were not found. Thesec components are supplied by Oracle Corportation and are part of the Oracle Version 7.3 (or greater) client software installation. You will be unable to use these drivers until these components have been installed"

Then power query error:

"ODBC: ERROR [IM004] [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV failed"

So now I'm a litte confused and don't understand what this means and what I've done wrong. Other posts here didn't point to the right direction (I think).