Page 1 of 1

Node.js SQL Adapter (firebird blob issue)

Posted: Fri Feb 08, 2019 1:56 am
by Barnaby
Hey,

When selecting a blob through the firebird SQL Adapter, a function (a data stream) gets passed back rather than a string, causing you to see the function in the report.
Blob.png
Blob.png (10.44 KiB) Viewed 2113 times
I've altered the adapter and got it working for the designer/viewer, but now I'm trying to generate a PDF via node.js.
stimulsoft-reports-js appears to use built in SQL Adapters, is it possible to alter them, or make it use external ones (as per the designer/viewer)?

I've tried to set Stimulsoft.StiOptions.WebServer.url, but requests timeout after 30 seconds at the start of report.renderAsync, it then does the SQL statements through the correct url, but when the report finishes no pages have been created.

Edit: I've found that I can use the following

Code: Select all

Stimulsoft.System.NodeJs.processFirebird = FirebirdAdapter.process;

Thanks,
Barnaby.

Re: Node.js SQL Adapter (firebird blob issue)

Posted: Mon Feb 11, 2019 7:34 am
by HighAley
Hello, Barnaby.

Did you solve the issue?
If not, write here and we will try to help you.

​Thank you.

Re: Node.js SQL Adapter (firebird blob issue)

Posted: Mon Feb 11, 2019 11:09 pm
by Barnaby
Yeah I solved the using by using an altered SQL Adapter.

There is still an issue with the blob fields in firebird using the default SQL Adapters, which you guys might want to fix in a future version.
But nothing is needed urgently for me.

Thanks.

Re: Node.js SQL Adapter (firebird blob issue)

Posted: Tue Feb 12, 2019 12:37 pm
by Lech Kulikowski
Hello

Ok.
Please let us know if you need any additional help.

Thank you.