Subject | RE: [ib-support] All about different connection strings? An update |
---|---|
Author | Alan J Davies |
Post date | 2002-11-06T07:32:28Z |
Hi
Further to the details on connection strings, I can complicate the issue by
adding the following list of errors when connecting via various options.
This applies to W2K servers, NT4 servers, W2K and Win98 workstations.
IP only, DHCP for address on clients, Novell Client for Windows, Client for
Microsoft Windows
Firebird 1.0 on server and Firebird Client on workstations
Server address is 192.168.0.15, client addresses 192.168.0.40 on
192.168.0.15 and aldis-server is set in HOSTS (correct settings)
192.168.0.15 and aldis-server is set in LMHOSTS (correct settings)
Data Source is shown in a listbox for user feedback
C:\APPS\MYDATABASE.GDB always shows on server regardless of settings
\\aldis-server\apps\mydatabase.gdb always shows on client
When Data Source is:
1
C:\APPS\MYDATABASE.GDB works ok on local/server and client machines
2
192.168.0.15:C:\APPS\MYDATABASE.GDB works ok on local/server machine
error on client machine
Dynamic SQL Error -901 feature is not supported. Program loads ok but no
database available, so the client is locating the correct folder
3
127.0.0.1:C:\APPS\MYDATABASE.GDB works ok on local/server machine
error on client machine
Unable to complete a network connection to host "127.0.0.1"
Failed to establish a connection
unknown win32 error 10061
4
localhost:C:\APPS\MYDATABASE.GDB works ok on local/server machine
error on client machine
Unable to complete a network connection to host "localhost"
Failed to establish a connection
unknown win32 error 10061
Sorry to spoil the party - but this is the direct opposite of a recent
email from Alan - another one, not me.
It would be good to resolve this because I know I will have a problem soon
with different IP addresses on a WAN - it must affect a lot of potential
users
Alan J Davies
Further to the details on connection strings, I can complicate the issue by
adding the following list of errors when connecting via various options.
This applies to W2K servers, NT4 servers, W2K and Win98 workstations.
IP only, DHCP for address on clients, Novell Client for Windows, Client for
Microsoft Windows
Firebird 1.0 on server and Firebird Client on workstations
Server address is 192.168.0.15, client addresses 192.168.0.40 on
192.168.0.15 and aldis-server is set in HOSTS (correct settings)
192.168.0.15 and aldis-server is set in LMHOSTS (correct settings)
Data Source is shown in a listbox for user feedback
C:\APPS\MYDATABASE.GDB always shows on server regardless of settings
\\aldis-server\apps\mydatabase.gdb always shows on client
When Data Source is:
1
C:\APPS\MYDATABASE.GDB works ok on local/server and client machines
2
192.168.0.15:C:\APPS\MYDATABASE.GDB works ok on local/server machine
error on client machine
Dynamic SQL Error -901 feature is not supported. Program loads ok but no
database available, so the client is locating the correct folder
3
127.0.0.1:C:\APPS\MYDATABASE.GDB works ok on local/server machine
error on client machine
Unable to complete a network connection to host "127.0.0.1"
Failed to establish a connection
unknown win32 error 10061
4
localhost:C:\APPS\MYDATABASE.GDB works ok on local/server machine
error on client machine
Unable to complete a network connection to host "localhost"
Failed to establish a connection
unknown win32 error 10061
Sorry to spoil the party - but this is the direct opposite of a recent
email from Alan - another one, not me.
It would be good to resolve this because I know I will have a problem soon
with different IP addresses on a WAN - it must affect a lot of potential
users
Alan J Davies