| Author |
Message
|
| DeadPool |
 Posted: Wed Jul 06, 2016 6:24 am Post subject: DB Resultsets Split |
 |
|
Apprentice
Joined: 27 May 2016
Posts: 30
|
All Long time reader
Have an issue whereby I am making a call to a database and retrieving via Stored Proc a Resultset.
On retrieval the Debugger is showing the same resultset name in 2 parts with two thirds of teh overall resultset in 1 part and the remainder in another.
Previously I have not seen this issue as the data was not large but this happens at approx 2149 chars of a total of 2450.
This seems very strange to me as I would have thought that the size of teh response would not affect IIB.
So I have to now merge the 2 result sets together.
and to my question
If they have the same name and reference how to do this?
Many thanks |
|
| Back to top |
|
 |
| mqjeff |
| Posted: Wed Jul 06, 2016 6:28 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
Have you confirmed that this isn't caused by the stored procedure?
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| DeadPool |
| Posted: Wed Jul 06, 2016 6:39 am Post subject: |
|
|
Apprentice
Joined: 27 May 2016
Posts: 30
|
jeff good to know minds think alike.
Stored proc is only passing back a single resultset
so the split should either be in the ODBC connection or IIB. |
|
| Back to top |
|
|
| mqjeff |
| Posted: Wed Jul 06, 2016 6:45 am Post subject: |
|
|
Grand Master
Joined: 25 Jun 2008
Posts: 17447
|
what's the odbc trace show?
what's the trace node output show? (probably the two result sets?)
What database? What's the odbc config look like?
_________________
chmod -R ugo-wx / |
|
| Back to top |
|
|
| DeadPool |
| Posted: Wed Jul 06, 2016 6:52 am Post subject: |
|
|
Apprentice
Joined: 27 May 2016
Posts: 30
|
Forgot to mention this is on a Windows OS
Tends to split it at 2033 chars, as if a max length)
Will get config etc
SQL Server 2014 |
|
| Back to top |
|
|
|
|
