I have raised this with IBM Support but thought I would ask if anyone has seen this.
We have an ODBC query against a PostgreSQL materialised view which returns 72,000 rows. Using ODBC in Excel all rows come through fine. In a TI any rows past 65536(2^16) have string values set to null and numeric values set to 0 (In summary, a bunch of commas is returned). Version 2.0.9.16 / 2.0.9.18. Tried both 32 and 64 bit drivers.
Anyone seen anything like this?
Issue with ODBC connections, rows past line 65536 nulled/zeroed
-
- Posts: 97
- Joined: Mon Jul 29, 2019 5:02 am
- OLAP Product: Planning Analytics
- Version: 2.0.9.x
- Excel Version: Office 365 16
Re: Issue with ODBC connections, rows past line 65536 nulled/zeroed
I've already answered my question.
I had this setting in my config.
SQLRowsetSize=100000
When I comment it out everything is ok. Looks like a bug there.
I had this setting in my config.
SQLRowsetSize=100000
When I comment it out everything is ok. Looks like a bug there.