Urgent! ODBC drivers not visible on Windows Server 2003 SE x64
773634May 18 2010 — edited May 21 2010Hi All,
I installed Oracle BI EE 10.1.3.4.1 with Oracle BI Apps 7.9.6.1 and Oracle BI DAC 10.3.4.1 (all 32bit applications) on Windows Server 2003 SE x64
I have the 32-bit JDK, 32-bit Oracle Client 10.2.0.1 and an Oracle 10g x64 EE Database.
I have two issues:
1. After installing all, I don't see the AnalyticsWeb ODBC driver nor the Oracle Merant drivers for Oracle DAC in the ODBC Admin Tool.
But strangly, I am able to connect to the repository via the AnalyticsWeb connection.... ???!!!
2. The other issue is that I can't create DWH tables from DAC with a created ODBC driver.
It fails with an "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified" error.
But this ODBC driver on the other hand, is visible in the ODBC Admin Tool and it tests succesfully!
Does anyone have a clue what causes this behaviour? I'm kind of stuck right now.
I've already found on the web that Windows x64 uses two ODBC admin tools.
A 32-bit in C:\Windows\SysWoW64\odbcad32.exe and a 64-bit in C:\Windows\System32\odbcad32.exe
However, no matter which one I click, it opens the same ODBC Admin Tool with the same visible (and unvisible) drivers.
Please help!!!
regards,
Daniel