Page 1 of 1

TUniConnection Firebird and Pooling

Posted: Thu 21 Jun 2018 19:56
by ozelaya2010
Hi,

When Pooling is set to false the following Query runs ok.
SELECT LSTA FROM STA WHERE ISTA = "4000"
When pooling is set to true I get SQL Error Column Unknown 4000

Any hints.

Thanks in adavnce,

Omar Zelaya

Re: TUniConnection Firebird and Pooling

Posted: Fri 22 Jun 2018 11:52
by ViktorV
Unfortunately, we cannot reproduce the issue on the latest version UniDAC 7.2.7.
We got the specified error, both when using the Pooling property and without it. Most likely, the error cause is related to the server functionality specificity, not the functionality of UniDAC. As we got the same error using the standard mean - isql.exe Firebird utility.
Please make sure that you are using the latest version of UniDAC 7.2.7 and the issue is not reproduced using the standard mean.
If this is so, in order for us to be able to give you a detailed answer, we need a sample demonstrating the behavior you mentioned. Therefore, please, compose a small sample demonstrating the described behavior and send it to us using the contact form https://devart.com/company/contactform.html including database objects creating scripts. Also, please specify the exact version of the server and the IDE you are using.