Hi Everyone,
I'm facing a scenario wherein I'm unable to see SQL ODBC sources when I'm running the server as an Application.
Interestingly, I'm able to see & use those connections from the same server when I run the server as a Service.
TM1 Version: TM1 9.5.2
ODBC connection : SQL Server.
I wonder what could be the reason behind this behaviour?
Has anybody faced this before?
Any clues?
Thanks.
Unable to see ODBC sources when running TM1 as an applicatio
-
- Community Contributor
- Posts: 127
- Joined: Wed Oct 14, 2009 7:46 am
- OLAP Product: TM1
- Version: 9.4
- Excel Version: 11
- Location: London
Re: Unable to see ODBC sources when running TM1 as an applic
Are you running the application as 32-bit and the service as 64-bit? I think you may need to check which ODBC data sources you have created. It might also be to do with the account running the service/ application. If you're on Windows Server 2008, try right-clicking and running as administrator for your application.
-
- Posts: 14
- Joined: Tue Apr 09, 2013 6:35 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2007
Re: Unable to see ODBC sources when running TM1 as an applic
Hi Dan,
Thanks for the reply. That looks like a simple trick.
I'll try & post the results here.
Thanks.
Thanks for the reply. That looks like a simple trick.
I'll try & post the results here.
Thanks.
-
- Posts: 14
- Joined: Tue Apr 09, 2013 6:35 am
- OLAP Product: TM1
- Version: 10.1
- Excel Version: 2007
Re: Unable to see ODBC sources when running TM1 as an applic
Hi Dan,
I tried your suggestion. I tried to run the application as an administrator user, however there were restrictions & right click did not give an option of administrator but different account users. Yet, I was able to run it as the user account that runs the windows service.
But in vain, the ODBC connection still doesn't appear in the list.
I tried your suggestion. I tried to run the application as an administrator user, however there were restrictions & right click did not give an option of administrator but different account users. Yet, I was able to run it as the user account that runs the windows service.
But in vain, the ODBC connection still doesn't appear in the list.
- paulsimon
- MVP
- Posts: 808
- Joined: Sat Sep 03, 2011 11:10 pm
- OLAP Product: TM1
- Version: PA 2.0.5
- Excel Version: 2016
- Contact:
Re: Unable to see ODBC sources when running TM1 as an applic
Hi
Have you set up the ODBC DSN as a System DSN rather than as a User DSN. If it is set up as a System DSN then it can be accessed by any user on the server. When in the ODBC set up dialog, make sure you go to the second tab as by default it opens on the first tab which is for user rather than system DSNs
Regards
Paul Simon
Have you set up the ODBC DSN as a System DSN rather than as a User DSN. If it is set up as a System DSN then it can be accessed by any user on the server. When in the ODBC set up dialog, make sure you go to the second tab as by default it opens on the first tab which is for user rather than system DSNs
Regards
Paul Simon