Excel 2010 64 bit
Windows 7 64 bit
Oracle instant client 188.8.131.52 64 bit
connecting to Oracle 11gR2 64 bit on Linux 5.8 64 bit
I have created a User DSN in Windows called "NITRO Oracle 11gR2 DB" using the Oracle 64 bit instant client driver 184.108.40.206. Configured as so
Connection test is successful.
In Excel 2010, I go to Data ribbon, From Data Connection Wizard
I then choose Other/Advanced, and then Oracle Provider for OLE DB.
I click next and then put in the data source, user name and password and click test, and it fails with Micosoft Data Link Error. http://i.imgur.com/zuv41.png
Do you know what I'm doing wrong?
12154 means the client couldn't resolve what you filled in for Data Source. What did you fill in for Data Source when configuring the OLEDB connection? It looks like "nitro" should be the correct thing to fill in, based on your statement that the ODBC DSN you configured works with it.