Subject Re: [firebird-support] Which Firebird ADO.Net client is compatible with Firebird server v2.0.x?
Author setysvar
Post date 2018-01-12T21:28:48Z
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 balintn@... [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