ODBO connection from 10.2.2 instance to PA instance

Post Reply
Catherine
Posts: 101
Joined: Wed May 20, 2009 7:30 am
OLAP Product: TM1
Version: 10.2.2 - PA
Excel Version: 2010
Location: Rennes, France

ODBO connection from 10.2.2 instance to PA instance

Post by Catherine » Tue Mar 12, 2019 11:08 am

Hi all,

Thanks to this very goo post :
https://tm1forum.com/viewtopic.php?f=21&t=13885
I managed to see PA instances from my 10.2.2 Perspectives.

Now I want to go one step further.
I'd like to make work a process using an ODBO connection. My process is located in a 10.2.2 instance, and I want to read information in a PA instance.
The ODBO connection does not work.
Has anybody managed to do this ?

Thanks in advance

User avatar
jim wood
Site Admin
Posts: 3667
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: ODBO connection from 10.2.2 instance to PA instance

Post by jim wood » Tue Mar 12, 2019 11:29 am

I'm not sure of the ins and outs of this (not sure if it's even possible) but my first inclination would be to overlay the ODBO drivers on the 10.2.2 machine with the ones from the PA machine, taking a backup first of course. I can only guess that the 10.2.2 drivers are not able resolve the connection.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

Post Reply