network connectivity?

[subworx]

hi there

i tried using ZEOS 6.5.1 alpha with delphi 2005 architect and firebird 1.5 embedded

i followed your easyQuery tutorial, everything works fine

at least, as long as the database is not located on a network drive

as soon as i map some unc path (\\server\share) to a drive letter (g:) and try to start the app from there, on startup i get the error:

SQL Error: Unable to complete network request to host "myserver". Failed to establish a connection. The system could not find the file specified.
. Error Code: -902. Unsuccessful execution caused by a system error that precludes successful execution of subsequent statements.

the firebird log says:
PC-04 (Server) Thu Jan 26 10:37:34 2006
WNET/wnet_error: CreateFile errno = 2

PC-04 is my machine, myserver is the machine the network share is on

hope you can help with my problem

thank you

Sub

[zippo]

Try to check if the share is read-only - it must not be!

If it not worx,, read the firebird manual - there are some cases when UNC is not allowed and the path must begin with a local drive (ex. C:)

Try to map the path to a drive Example: "net use F: \\myserver\share" and then use the database path in format F:\myDB.

I'm to an firebird expert, so maybe I'm talking bullshit..

[subworx]

hi zippo and thanks for your quick answer

the thing is: i never use any UNC paths

the directory \\myserver\someshare always is mapped to my drive G: \, so it would be G: \MyApp\database.fdb which should be accessed, but the error says \\myserver isn't accessible, instead of anything with the drive letter.

or rather ... the TZConnection component is set to "database.fdb" without any path, meaning it's located in the current directory. running it locally works, even when copying .exe, .dll, and database to another computer.
running it remotely (on the shared drive) with the same setting does not work.

i do have write permissions on that share/drive, else i would not be able to put my program there

i will have another look at the firebird manual though

again, thank you

greets
Sub