Dimitry Sibiryakov wrote:

>On 13 Apr 2005 at 10:53, Sam Hunt wrote:
>
>
>
>>Dbname=\\NSTI-2\C:\Program Files\AT6TestData\AUCTIONTRACKER.FDB;
>>
>>
>
> Ok. I'm not so good in long explanations as Helen, but I try.
>
> You use named pipes as connection protocol. This is the source of
>your problem, as I told you (or somebody else?) many times before.
> Why named pipes are in trouble? Because of this function, called in
>fbclient.dll or fbserver.exe: "ImpersonateNamedPipeClient". You can
>read what it does in MSDN.
> In short: it applies user name, password and rights of user
>currently logged in on client computer to server's process. So, this
>user must have full access to the database and the password database.
> I.e. if you connect to FB server from computer SAMS_COMP where you
>are logged in (locally) as SAM, user SAM on server (NSTI-2) must have
>read/write access rights on file AUCTIONTRACKER.FDB _and_
>FBSECURITY.FDB.
>
> You can avoid all these troubles using plain TCP/IP. Just change
>connection string to
>"NSTI-2:C:\Program Files\AT6TestData\AUCTIONTRACKER.FDB"
>
> This long-standing source of supporing business is removed in FB2.
>Thanks to Dmitry Yemanov.
>
>

OK. I set up the dsn's on the server ok, but when I use "NSTI-2:C:\..."
instead of \\NSTI-2\C:\..." to set up the dsn's on the client , I
receive the error:
Unable to complete network request to host "NSTI-2".
Failed to establish connection.
An invalid argument was supplied.

I have an entry in the C:\Windows\Systems32\Drivers\Etc\Hosts file that
looks like:
192.168.0.11 NSTI-2

AND... when I substitute 192.168.0.11 for NSTI-2 in the data source name
on the client pc, I get the same error - the top line reads:
Unable to complete network request to host "192.168.0.11", instead.

All the PCs on my company's (small) network have an IP address of
192.168.0.11 with an additional segment like ":755", so the complete IP
address might be something like 192.168.0.11:755. The ":755" changes
for a given PC every time it is rebooted. Does my server need a static
IP address?
Thx so much for your time.
Sam Hunt