Oracle ODBC and 9.1 SP2 U3

[mzatta]

Have installed 64 Oracle Drivers (Oracle 10) on the 9.1 SP2 U3 TM1 Server and having an issue seeing the DataSource created for a TI process, it appears to only be showing the 32 bit data sources.

Is there a setting somewhere to tell the TM1 server to look at the 64 bit datasources?

Bit of a rougue install here I think

thanks

Marco

[Olivier]

Hi Marco,

Can't help much as i never had this issue before but this post might ring a bell>>>

http://forums.olapforums.com/viewtopic. ... c+64#p9574

Hope that helps,

Kind regards,
Olivier

[mattgoff]

Sounds like you're running the 32-bit TM1 server. If so, you need the 32-bit Oracle driver. It doesn't matter what version of Oracle you're running-- the driver "bitness" needs to match the TM1 "bitness".

Matt

[mzatta]

Nope, Matt

Definately 64 Bit 9.1 SP2 U3 TM1 with 64 Bit Oracle ODBC Drivers.

[Michel Zijlema]

Hi Marco,

Please note that when you setup a DSN using a 64-bit driver on a 64-bit Windows OS you have to use the odbcad32.exe located in the %Windir%\System32 directory and not the odbcad32.exe in the WoW64 directory. Sytem32 is the 64-bit system directory and WoW64 is the 32-bit compatibility layer (hail to the great minds at Microsoft).
Also note that your DSN's need to be setup as System DSN for TI being abe to see the DSN.


Michel

[mattgoff]

64-bit applications can't see 32-bit DSNs without using AXNET. I assume you haven't done that, so you're either seeing 64-bit DSNs and you haven't set yours up correctly yet (per Michel's post) or you're inadvertently using a 32-bit TM1 server.

Matt