| Subject | RE: [ib-support] Re: Cannot Attach to Password Database |
|---|---|
| Author | Helen Borrie |
| Post date | 2002-01-29T09:53:52Z |
At 09:27 AM 29-01-02 +0000, you wrote:
But the example given is incorrect for a remote client. The IP address 127.0.0.1 is localhost - clients can only connect to localhost on their own machines. Also, Win95 clients MUST use a server name, not an IP address.
Define a name for the server - anything you like if your server doesn't already have a name (or even if it does) - and make a HOSTS file for each client (including the server machine). (If the server already has a name on the network, use that name).
On Win95 this file should be located in the \windows directory. If it is not there, and the file hosts.SAM is there, then copy hosts.SAM and rename the copy to HOSTS.
Open HOSTS with a text editor (Notepad is fine) and enter a line like this:
111.111.111.111 OurServer # Firebird server
In place of 111.111.111.111 above, enter the IP address of the server in the network, e.g. 192.12.13.1
Save the HOSTS file.
Of course, the client have to have TCP/IP installed!
Test the network connection with ping (Start menu | Run.. and type in ping OurServer).
If the client is talking to the server you should see a DOS screen with four responses from the server.
Change the connection string in your application so it is:
Ourserver:C:\path\mypath\mydb.gdb
All going well, it should connect.
cheers,
Helen
-----Original Message-----
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________
>RodCorrect for the path - that is, the syntax is correct for connecting in TCP/IP, whereas your existing path is for Windows networking (NetBEUI) and cannot work unless the server is running on an NT or W2K machine.
>change the serverpath=server:c:\path\mydb.gdb that should make it use TCP/IP
>connection.
>If that fails chnage the name of the server to the IP address of the server
>127.0.0.1:c:\data\data.gdb for example
But the example given is incorrect for a remote client. The IP address 127.0.0.1 is localhost - clients can only connect to localhost on their own machines. Also, Win95 clients MUST use a server name, not an IP address.
Define a name for the server - anything you like if your server doesn't already have a name (or even if it does) - and make a HOSTS file for each client (including the server machine). (If the server already has a name on the network, use that name).
On Win95 this file should be located in the \windows directory. If it is not there, and the file hosts.SAM is there, then copy hosts.SAM and rename the copy to HOSTS.
Open HOSTS with a text editor (Notepad is fine) and enter a line like this:
111.111.111.111 OurServer # Firebird server
In place of 111.111.111.111 above, enter the IP address of the server in the network, e.g. 192.12.13.1
Save the HOSTS file.
Of course, the client have to have TCP/IP installed!
Test the network connection with ping (Start menu | Run.. and type in ping OurServer).
If the client is talking to the server you should see a DOS screen with four responses from the server.
Change the connection string in your application so it is:
Ourserver:C:\path\mypath\mydb.gdb
All going well, it should connect.
cheers,
Helen
-----Original Message-----
>From: rodbracher [mailto:rod@...]All for Open and Open for All
>Sent: 29 January 2002 09:13
>To: ib-support@yahoogroups.com
>Subject: [ib-support] Re: Cannot Attach to Password Database
>
>
>On the client, there is a shortcut to the exe on the server.
>On the client, there is an ini file that points to the database on
>the sever path=\\server\c:\path\mydb.gdb for example. The username
>and password are hardcoded on app startup.
>
>This works 100% on another network and here at work, but if this is
>not the best way to go about things, please say.
>
>I have never heard of HOSTS - the network is TCP/IP
>
>Rod
>>
>> How is your client application connecting to the server? (Server,
>Path)?
>>
>> Do the client computers have HOSTS file entries for the server?
>>
>> H.
>>
>>
>> Firebird Open SQL Database · http://firebirdsql.org
>> _______________________________________________________
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Firebird Open SQL Database · http://firebirdsql.org
_______________________________________________________