Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Excel ODBC / TNSNAMES issue...
Running Windows 7 SP1 (32-bit), Office 2010, Oracle Client 11g, and two System DSNs that point to Oracle databases. I can resolve both ODBC conenctions via a command prompt and tnsping, and I can connect to the ODBC connections via TOAD for Oracle.
Where I'm stuck is that when I attempt to connect within Excel / Power Pivot, it returns a TNS listener error. The issue is user specific as I can switch users and connect via Excel with no issues. Looking for a user-specific setting, registry setting or even a cache setting that may store this info.
Fuel
