TM1 - 10.2 - 64bit ODBC

[babuganesh2000]

I am very new to TM1, I apologize for any mistakes below.

I was trying to use TI to import Dimensions/Cubes.

When I select the ODBC and click browse I get an error: An error occurred while retrieving datasource names from the server.

Attached is the error I am getting. Please advise.

I do have couple of more DSN's, because it is 64 bit. I tried both 32 and 64 bit and ensure there is a DSN available.

%systemdrive%\Windows\SysWoW64 folder and %systemdrive%\Windows\System32 folder.

Thanks,
Ganesh

[EvgenyT]

Hi,

you can only have ONE dsn type. You cannot have both active.

Remove the 64 bit ODBC connection and re-add it as a 32 bit ODBC connection.

[babuganesh2000]

done, same problem sir...thanks. appreciate if you could help me

[EvgenyT]

how did you add your odbc datasource?

[babuganesh2000]

Sorry for the late reply...

I have created in both ways with different names.
%WINDIR%\System32\odbcad32.exe
%WINDIR%\SysWOW64\odbcad32.exe

Later, please see below screen shot. Ironically the local server is able to hit the ODBC what I was trying to connect but not the application server
in my example FoodMart.

Local.gif (93.21 KiB) Viewed 9365 times

FoodMart.gif (90.87 KiB) Viewed 9365 times

[tomok]

You should probably update your profile. Are you really on version 9.0???? That is waayyyy out of support. If you are, you should realize that only 64-bit ODBC connections will work with the 64-bit server in that version. The reason your "local server" works is because the Archiect/Perspectives client (under which the Local Server program runs) is 32-bit and it can recognize the 32-bit DSN.

Other than that I have no clue. I haven't worked with that version in over 10 years.

[babuganesh2000]

Thanks for the reply....
You should probably update your profile.
How can I do this ?
Are you really on version 9.0????
I am using 10.2 version of TM1, I did not mention I am using 9.0, you can see subject of this thread as well as 10.2.

Can you please see, how come local server can access the DSN and the application server couldn't on the same server ?

I really appreciate your time for helping me out. thanks...

Thanks,
Ganesh

[jim wood]

If you look to the right of your post it says version 9.03. Although it also says SSAS, not TM1.

[babuganesh2000]

Finally was able to figure out what is going wrong.
http://www.orionscache.com/2012/12/crea ... ws-2008r2/

Mine is a virtual machine, I just followed the instruction exactly as per the above link. All works.

First.jpg (34.04 KiB) Viewed 8731 times

second.jpg (108.93 KiB) Viewed 8731 times

[EvgenyT]

Hence what I said to you before

you can only have ONE dsn type. You cannot have both active.

Remove the 64 bit ODBC connection and re-add it as a 32 bit ODBC connection.

[babuganesh2000]

Thank you Evgeny...I really appreciate it.

[babuganesh2000]

For the benefit of others, few more clarification.

1. On a 64 bit Cognos TM1 on top of Windows 2008r2 x64 , local server uses 64 bit driver of the dsn and the application server
uses the 32 bit driver. Please see screen shot below

64_bit_local.gif (106.49 KiB) Viewed 8610 times

32_bit_application_server.gif (101.04 KiB) Viewed 8610 times

2. Create System DSN, in my case I was wasting time by creating user dsn. My bad.

3. Certain things about Oracle on Windows 32/64 bit.
Microsoft do not have a 64 bit driver(MSDAORA which is 32 bit) connecting to Oracle, in that case you have to install the 64 bit version of Oracle's Driver (OraOLEDB.Oracle) and on top of OraOLEDB.Oracle have to create the systemDSN.

So you have to decide if you are going to make a connection to Oracle on the Local Server or Application Server created by you.