Subject TCPIP vs Piped lines
Author Gustavo
Hello:

I have an application installed in a network with the following technical data:

Delphi 5 with IBX
FireBird 2.1.2.18118 SS
Server: Windows 2003 Server
Clients: Windows XP SP3

Using the application in the server or connecting to the server via Terminal server, everything works perfect.

Using the application in a PC client of the local network, ALMOST everything works perfect. In only 3 of the tables, when the application executes a SELECT * FROM <TableName>, the application "hangs". In firebird.log I see the following:

INET/inet_error: read errno = 10054

Looking for this error code, I found that may be this is because the table has too many fields. But this is not the case because it happens with a table with 93 fields, but it does not happen with other tables that have, for example, 145 fields.

To access the database I was using TCPIP style. For example: SERVER:ALIASOFMYDATABASE. Following a suggestion I found, I changed this to piped lines. For example: \\SERVER\ALIASOFMYDATABASE. With this change, now ¡it works!

But I have other customers with networks similar to this one and everything works fine using TCPIP. So I guess, there has to be something that is causing this problem in this case.

Then my question is:

What may be causing this?

Thanks in advance

Gustavo

[Non-text portions of this message have been removed]