Web Application - error 10054 - URGENT...PLEASE HELP
Hi guys, I am getting a very annoying error with my web application an would be grateful if you could help ( hence the points!).
I am using Delphi 6 with Interbase 6, and I an connecting to the database via dbx. I have a query that requests rows from the database, and I am trying to display it on the web page using a TSQLQueryTableProducer. When I am developing the application I am confident that it works (as when I double click on the TSQLQueryTableProducer in the WebModule window I can see the required retrieved data.) The problem occurs when I try to display this through the browser. I get a 'page cannot be displayed error'. On examining the Interbase log, I can see that I am getting the error:
INET/inet_error: read error = 10054
I have looked at the Borland site for a solution (restarting the Interbase server) but this again failed with the same message. I am using IIS on Windows 2000 Server.
10054 is a Winsock error indicating that the connection has been reset. Generally, this is from a connection that was terminated, such as a user turning off their computer
without closing the program connected to the Interbase
server.
Besides this, some users also reported they get the error when the server's cpu usage is constantly at 100%. The connection then timed out after a few seconds...
Could you post some code where you connect to the Interbase server in your web application?
without closing the program connected to the Interbase
server.
Have you tried any of the solutions from http://community.borland.com/article/0,1410,25340,00.html ?
Besides this, some users also reported they get the error when the server's cpu usage is constantly at 100%. The connection then timed out after a few seconds...
Could you post some code where you connect to the Interbase server in your web application?