I seem to have isolated what was happening, though, and it seems mostly my fault, although the error message was misleading (the error message i think is passed from firebird anyway, and i have no idea why it picks up the path from the openfiledialog that has since been disposed). I update three tables within one transaction, and before the third update run a check on the data against what's in the database. This check uses a separate connection. Firebird throws the error because there is more than one connection open to the embedded database at once.
This behaviour seems fair enough, i guess i just need to brush up on ADO.NET transaction and connection behaviour. I didn't realise that a transaction leaves an open connection.
On 27/01/06, Wes Hodges <[EMAIL PROTECTED]> wrote:
I believe by default Firebird will refuse to open a database on a
network share. This can be overridden in the firebird.con file.
Property RemoteFileOpenAbility = 1. There is a big warning in the
sample firebird.conf file.
Wes
Ben Hart wrote:
> In my rush to get help i didn't realise something very important.
> CPTMST001 is the server our database is on, CPTCFS001 is a fileserver
> we keep other things on.
>
> Before getting the error we use an OpenFileDialog to open an excel
> file, which is then read and imported into our system. The file I was
> opening is on the file server CPTCFS001. The error "Unable to complete
> network request to host \"CPTCFS001\".\r\nFailed to establish a
> connection." could be related to the fact that just previously an
> OpenFileDialog was directed to CPTCFS001.
>
> But I'm still clueless as to what is really going on :-(
>
> Thanks again,
> Ben
-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Firebird-net-provider mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
