Subject Re: [firebird-support] Re: How can I connect to Firebird server from account without administrative privileges?
Author Helen Borrie
At 05:11 PM 18/01/2008, you wrote:
>(I am new in firebird). It did work after I prefix the IP address,
>Thanks.
>SQL> create database '127.0.0.1:bbb.fda';

That's still wrong. Should be 127.0.0.1:D:/full/path/to/database, which is the same as localhost:D:/full/path/to/database

>Commit current transaction (y/n)?y
>Committing.
>SQL> commit;
>
>
>Is there any way I can set the server to not requiring prefixing the
>IP address?

If you want to run the scripts for Firebird 1.5.x Classic, then No. If you want to run the scripts from a VPN client shell, then No. And, whatever you do, you will encounter more and more problems if you continue ignoring correct syntax and refusing to refer to the right documentation.

IP address is less safe than node name if you can't guarantee static IP addresses. The IP address 127.0.0.1 is localhost. It *is* static but it is not available to all Windows client environments.

>As it works in most of machines, we put that in the build
>script without the prefix. I need to fix this problem in my
>development environment.
>
>I am using Firebird 1.5.1 (Win32 Build)
>in windows server 2003.

A tip: since Firebird is client/server software designed to run on a network, it would serve you better to try to understand how connections work in the different server models and connection protocol environments than to chase that elusive magic recipe. Any cook will tell you, there's a right way to cook rice and a *different* right way to make a soufflé.

./heLen