Page 1 of 1
Oracle ODBC for a TM1 64 bit server
Posted: Tue Oct 06, 2009 3:29 pm
by rodrigo
Hello
A little about servers, we would like to know if somebody connected a Oracle 10g database on Solaris (32-bit) to a Win 64-bit TM1 Server via ODBC.
Free drivers exists?
Thanks,
Re: Oracle ODBC for a TM1 64 bit server
Posted: Tue Oct 06, 2009 10:55 pm
by lotsaram
For 9.1 you can use the 32 bit AXNET gateway and use the native Oracle 32 bit drivers.
For 9.4 series AXNET has been discontinued and 64 bit drivers need to be sourced. I believe the reason for AXNET gateway being dropped was that it does not support unicode. This is a bit of an issue for x64 sites on 9.0 or 9.1 considering an upgrade to 9.4 as it is a bit of a show stopper if there is an Oracle data source. If you are on 9.1 this shouldn't affect you but given how common this scenario must be it is very surprising that IBM haven't come up with a better solution than just telling customers "go and find your own drivers."
Re: Oracle ODBC for a TM1 64 bit server
Posted: Wed Oct 07, 2009 1:56 am
by mattgoff
rodrigo: Yes, you can get free 64-bit Oracle drivers directly from Oracle. You'll need both the Instant Client and ODBC installers.
lotsaram: I'm not following your logic. Why would rodrigo want to use AXNET when 64-bit Oracle drivers are readily available? AXNET is a kludge for situations when running 64-bit TM1 and no 64-bit ODBC driver is available.
Matt
Re: Oracle ODBC for a TM1 64 bit server
Posted: Wed Oct 07, 2009 3:43 am
by lotsaram
I agree AXNET is a kludge and better avoided if possible, just that in the past I have had a lot of trouble sourcing Oracle 64 bit drivers as none were available from Oracle. If this has changed for the better then that is great news as x64 is the future.
Re: Oracle ODBC for a TM1 64 bit server
Posted: Wed Oct 07, 2009 1:26 pm
by mattgoff
Re: Oracle ODBC for a TM1 64 bit server
Posted: Thu Oct 08, 2009 2:21 pm
by rodrigo
Thanks Guys, I thought axnet was something only on 8.x versions.
Thanks Matt for providing the link, 64-BIT is going straight forward...
Re: Oracle ODBC for a TM1 64 bit server
Posted: Tue May 25, 2010 8:01 am
by jstrygner
I am confused about the native driver to Oracle database.
For 9.1 you can use the 32 bit AXNET gateway and use the native Oracle 32 bit drivers.
Does it mean, 9.1 has a native OCI for Oracle (so not the ODBC which is slower)? Is that right I can query from 9.1 much, much faster Oracle databases than from later versions of TM1?