Subject RE: [firebird-support] Problem getting embedded server to work on a network drive
Author Alan McDonald
> My application works fine when installed on the local hard drive of my
> PC (C:\MyApp), but when I move it to a network drive on any of my
> servers (e.g. S:\MyApp) where S: is mapped to a share on the server I
> get the following error:
> SQL Error: Unable to complete network request to host "MyServer".
> Failed to establish a connection. The system cannot find the file
> specified. .Error Code: -902. Unsuccessful execution caused by a
> system error that precludes successful execution of subsequent statements
> The server is not running Firebird. I have tried both 1.5.2 and 1.5.3
> versions of fbembed.dll. I have tried using a network drive on a
> Windows 2003 server, another Windows XP pc, and another Windows 2000
> pc all with the same results.
> Should embedded server work off of a networked drive? If so, how do I
> fix this?
> Thanks,
> paul

no - it doesn't woprk across network shares - it can't lock the file
reliably so it will only work on a local drive