Hi All,
I'm using PAX 2.0.8
We have a new process that connect through ODBC to a view in Oracle 11g.
While i'm getting results in PL-SQL, tm1 showing me only the view headers (wo data).
Based on posts in this forum, I already done the follows without any success.
1. Checked that cfg file contains:
SQLFetchScroll=T
UseSQLExtendedFetch=T
2. I checked only one column to make sure there is no problem with one of the column and it still shows nothing
Thanks for helping
Roei
No ODBC preview
- jim wood
- Site Admin
- Posts: 3951
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: No ODBC preview
Are you using the same user in the ODBC as you are when running the query yourself? Sounds like security rights for the ODBC user to me.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
- roei61
- Posts: 41
- Joined: Wed Aug 22, 2012 5:44 am
- OLAP Product: PAX
- Version: 2.0.7
- Excel Version: 2016
- Location: Israel
Re: No ODBC preview
Hi,
Thanks for your answer.
Yes, it's the same user and still don't work
Roei
Thanks for your answer.
Yes, it's the same user and still don't work
Roei
-
- Posts: 124
- Joined: Tue Jun 13, 2017 3:20 pm
- OLAP Product: TM1
- Version: 10.2.2
- Excel Version: 2010
Re: No ODBC preview
Hi,
Do you still have the issue? I think only one of the parameters cab be used in one setting. I am not sure.
Paul.
Do you still have the issue? I think only one of the parameters cab be used in one setting. I am not sure.
Paul.