Subject Re: [firebird-support] error upon connecting to database from remote client.
Author Aage Johansen
Adrian Wreyford wrote:
> ...
>
>>Which version of Fb?
> 1.5.1.4481
>
>>Take a look at your connections string. Why not use TCP/IP, with:
> NEWSERVER:C:\PRAX\prax.gdb
> I'm using: \\newserver\c:\prax\prax.gdb
> The format you suggest, which is valid doesn't want to work .. I don't know
> why.
> Your "C:PRAX\" doesn't look too good.
> See above comment

I would suggest that you investigate your tcp/ip problem.
- Is the fbserver running?
- Can you connect locally (running on the server)?
- Is the server name known at the client? (DNS? Hosts file?)
- Can you ping the server?
- If ping NEWSERVER fails, try with ip address (ping xxx.yyy.zzz.abc).
If this fails, check whether tcp/ip is working at all (and no
firewall stops your requests). Check that the server is allowed
to answer pings.


>
> Don't define "share" for your database.
> I'm sharing the NTFS folder c:\prax where the database resides.
> Using "prax.fdb" might be better than "prax.gdb" (with WinXP).
> Will give it a go!
>
> "CreateFile failed" could be a matter of giving access (to the database
> directory and temp directory) to the user the Fb runs under or was
> installed by.
> So you suggest I share the Firebird install folder?

Not at all. Get tcp/ip working. Remove the shares. Period.
Note the the fbserver process must have sufficient rights to create
temporary files, and also to open (read/write) - and possibly create -
databases. I don't use XP myself, so I cannot advice on the details.


--
Aage J.