[Firebird-net-provider] I/O error for file CreateFile (open) "DRAGON.fdb"

[Ben H. <ben...@gm...>]

Hello

I spent a lot more time looking into this, and seem to have isolated what
was causing it. If i lauched my app (which firstly does a check of a table
in a database, and waited 15+ seconds and opened a certain form, the bug
popped up. 15 seconds was the Connection Lifetime property within my
connection string. It seemed that if i waited longer than the connection
lifetime the error was thrown.

Setting the Connection Lifetime to 0 prevents the problem. Can you please
give some advice around connection pooling and an embedded database? Is
setting the Connection Lifetime to 0 going to cause a problem later? Have i
done something stupid that's causing this behaviour? Should i be using
connection pooling at all?

Thanks,
Ben