Back to forum list… Back to Issues and Problems...

DB Reader - An invalid character was found in text context (1 reply)

David F
6 years ago
David F 6 years ago

I am getting this error when reading from a database view. The database view returns 136 rows in sql. The DB Reader preview originally returned all 136 rows but after some fields were added to the reader's select statement, the preview only returns the first 64 of these rows. Is the error triggered by something on the 65th row of the added fields? I did notice that one of the added fields on the 63rd and 64th row contained a : and a /. I have replaced these with - (hyphen) but the error still occurs. Any ideas about how to resolve this would be welcome.  

Support
6 years ago
Support 6 years ago

Be careful of non-printable characters such as backspace & vertical tabs. These characters will cause an error once they're consumed by IMan.

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close