As a shot in the dark (since it is not consistent, but more of a problem
on a slow computer): Could it be related to some timeout issues, and
that increasing ConnectionTimeout or CommandTimeout could help?
But Mark is right, you should post your problem on another list with far
more detailed information about the system and the error (e.g. it is
unlikely to be a timeout problem if your table contains only a few records).
Set
Den 12.01.2018 15:11, skrev B?lint Nagy [email protected]
[firebird-support]:
Hi,
I need to connect to a Firebird v2.0.3 database from .Net.
I downloaded the current Firebird ADO.Net provider about two months
ago, then the current one (5.12.1.0), and implemented all the
necessary queries for my app.
I the development environment it is quite stable, about 95% of the
time queries succeed. In a test environment (with a bottom of the line
PC with weak CPU and disk) queries fail about 60% of the time.
The failing queries are syntactically correct. If I run them from
IBOConsole, they succeed. Also, the query failures are not consistent:
the same query succeeds some times and fails some other times.
I suspect there is an incompatibility between the server and the
ADO.Net provider.
Can someone advise on the client version (?) to use?
Any other ideas I could try?
Thanks,
B
