Problem

You are running Windows XP with Service Pack 2 and get this error:

Connection failed, please check location details. The error message was Unable to complete network request to host server. Failed to establish a network connection. Unknown Win32 error 10060.

Solution

The Windows XP Service Pack 2 installs a new security centre into your Control Panel which comes with a Firewall. When this Firewall is turned on you will most likely find that Sportzware Central will no longer work in a network environment.

The following information applies only to users of Sportzware Central who are operating in a network environment, have Windows XP as their operating system and have Service Pack II installed. After installing Windows XP Service Pack II on the server machine, users on client machines may experience difficulties with connecting. As part of the Service Pack you will now find in your control panel an icon titled Security Centre. This checks to ensure that you have a virus scanning program installed on your computer and also controls and turns on the Windows XP Firewall by default. The cause of the problem experienced by the client machines, is that the firewall is now preventing successful connections to the Firebird Database. In order to overcome this problem, the following is recommended:

  1. Click on the ‘Start’ menu icon at the bottom left corner of your screen

  2. Select ‘Control Panel’

  3. Click on the icon titled ‘Security Centre’, if you are in ‘Category View’ or if you are in ‘Classic View’ double click on the ‘Security Center’ icon.

  4. Click on the ‘Windows Firewall’ icon

  5. Click on the ‘Exceptions’ tab

  6. Click on ‘Add Port’

  7. Enter the name as ‘gds_db'

  8. Enter port as ‘3050’

  9. Select ‘TCP’ as the protocol

  10. Click on the ‘OK’ button

When you now attempt to connect from the client machine to the server you should experience no difficulties.