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
