Interbase Error 10055
TCP/IP connection with an error (winsock) 10055 after a couple of days running. The Delphi application starts 60 threads and each thread opens a connection to an Interbase database using IBX and TCP/IP. Both application and Interbase are in the same computer. I know that Windows allows (by default) about 4000 sockets in listenning state, after that an error (10055) is issued. My program is starting 60 TCP/IP connections only, but I am getting the same error. Any help ? Thanks. Fernando. José Fernando da Silv Delphi Developer Sat, 09 Jul 2005 20:07:12 GMT Re:Interbase winsock error 10055 I 'll investigate that limitation. But the application is a telephony application, and it is normal to use 20 or more threads to handle each line (telephone). I saw that when I use localhost in the path to the database, ie. IBDatabase.databasename := LocalHost:C:\App\DB\database.gdb, the error is issued. When I use the the computer's IP address the error is not issued, but I tested the application only for two days, I am not sure if it will be running after one week. Do you think there is any difference between using the keyword localhost and the real ip address ? Thanks, Fernando. "Craig Stuntz [TeamB]"
this time. WSAEACCES (10013) Permission denied. An attempt was made to access a socket in a way forbidden by its access permissions. An example is using a broadcast address for sendto without broadcast permission being set using setsockopt(SO_BROADCAST). Another possible reason for the WSAEACCES error is that when the bind function is called (on Windows NT 4 SP4 or later), another application, service, or kernel mode driver is bound to the same address with exclusive access. http://www.delphigroups.info/2/ca/276838.html Such exclusive access is a new feature of Windows NT 4 SP4 and later, and is implemented by using the SO_EXCLUSIVEADDRUSE option. WSAEADDRINUSE (10048) Address already in use. Typically, only one usage of each socket address (protocol/IP address/port) is permitted. This error occurs if an application attempts to bind a socket to an IP http://www.firebirdfaq.org/faq119/ address/port that has already been used for an existing socket, or a socket that was not closed properly, or one that is still in the process of closing. For server applications that need to bind multiple sockets to the same port number, consider using setsockopt(SO_REUSEADDR). Client applications usually need not call bind at allconnect chooses an unused port automatically. When bind is called with a wildcard address (involving ADDR_ANY), a WSAEADDRINUSE error could be delayed until the specific address is committed. This could happen with a call to another function later, including connect, listen, WSAConnect, or WSAJoinLeaf. WSAEADDRNOTAVAIL (10049) Cannot assign requested address. The requested address is not valid in its context. This normally results from an attempt to bind to an address that is not valid for the local machine. This can also result from connect, sendto, WSAConnect, WSAJoinLeaf, or WSASendTo when the remote address or port is not valid for a remote machine (for example, address or
instructions: Windows Mac Red Hat Linux Ubuntu Click URL instructions: Right-click on ad, choose "Copy Link", then paste here → (This may not be possible with some https://sourceforge.net/p/firebird/mailman/message/7127201/ types of ads) More information about our ad policies X You seem to have CSS turned off. Please don't fill out this field. You seem to have CSS turned off. http://firebird-odbc-devel.narkive.com/bkeNGhWg/connection-lost Please don't fill out this field. Briefly describe the problem (required): Upload screenshot of ad (required): Select a file, or drag & drop file here. â â Please provide the interbase error ad click URL, if possible: Home Browse Firebird Mailing Lists Firebird A powerful, cross platform, SQL database system Brought to you by: alexpeshkoff, asfernandes, awharrison, cincura_net, and 6 others Summary Files Reviews Support Wiki Mailing Lists News Code Cvs Git firebird-checkins firebird-devel firebird-docs firebird-net-provider firebird-odbc-devel firebird-oledb firebird-test firebird-website [Firebird-odbc-devel] Connection lost [Firebird-odbc-devel] Connection lost From: Gerardo Czajkowski
and successfully connects to FB server, and after afew trannsactions connection is lost and reconnection attempts randomlywork.This is the error message I get:******** Error Message:Error NÂș: 1526Message: Connectivity Error: Unable to complete network request to host"MYSERVER".Failed to establish a connection.unknown Win32 error 10055ODBC - Message: Unable to complete network request to host "MYSERVER".Failed to establish a connection.unknown Win32 error 10055ODBC - SQL Status: 08004ODBC - Error NÂș: 0ODBC - Connection NÂș: 44Extra:Line NÂș: 171******* Message endsEnvironment info:OS: Base Win98se, also tried on another machine with allexistent patches installed and latest MDACFB server: 1.5 build 4306ODBC driver: 1.02.00.67Application made with VisualFoxPro 8 sp1.connstring = "DRIVER=Firebird/Interbase(r) driver"+ ";UID=myuser"+ ";PWD=mypassword"+ ";DBNAME=MYSERVER"+ ":C:\mypath\mybase.fdb"+ ";DIALECT=3"+ ";CHARSET=ISO8859_1"I know there's not a VFP issue because the same app is prepared to workindifferently with either M$$QL and Firebird, and using M$$QL thisdoesn't happen.This only occurs if application/FB server are installed on a Win98machine, on W2k all work perfectly.If this can be solved, great! If not it seems that my customer will aveto upgrade their server ;-)Thanks in advance,Gerardo Gerardo Czajkowski 2004-06-23 21:42:03 UTC PermalinkRaw Message Post by Gerardo CzajkowskiIf this can be solved, great! If not it seems that my customer will aveto upgrade their server ;-)Well, I solved my problem. Lurking on the brand new help file (greatwork guys!) I found that it's not necessary to include 'SERVER:' atDBNAME option. I removed it and problem solved!I still have to test a win98 server - win98 terminal schema... (I haveone win98 and one w2k machine here)A note apart: VFP has SQLCONNECT functions that allow to man