PDA

View Full Version : Connecting Excel 2007 with Oracle DB



NomalAnomaly
10-03-2010, 09:06 AM
Hello,

I am trying to connect Excel with my company's Oracle DB. I am doing so via the Data Connection Wizard. Eventually, when I test the connection I instantly get the error stating that Oracle client and networking components were not found.

I did however install the newest version of Oracle's mini client, which includes the ODBC library.

Any ideas why Excel doesn't recognize the required components on my machine?

Thanks in advance.

Bob Phillips
10-03-2010, 10:13 AM
Wouldn't you be using an OLEDB connection with Oracle?

NomalAnomaly
10-03-2010, 10:17 AM
ODBC is supposed to work as well. But actually I tried both and got the same error (AFAIK the OLEDB components are also supposed to be installed along with the mini client which I have on my machine).

Any ideas?

deyken
10-04-2010, 07:43 AM
Hi There,

Check your VBA References. Most Database platforms use DLLs that are present on your machine after installing the Oracle client software/extensions, but must be explicitly referenced.