Webserver Big Problems

[osquiabro]

Hi, i have app compile in two differents version one in c6.3 and nt 7.33 sql server 2008 in port 2339 this version run as rock solid for the past 4 years over 2400 users without any problem and running as services.

The second app is compile with c10 and nt 8.61 in port 88 same database, no user because is a test app with new features but this version is hanging every day, i believe is a problem with connection to sql, but same app with version 6.3 and nt 7.33 don't present this problem, what change after this build that affect the connection??

This is very important find a solution before buy nt9 upgrade and result with same problem.

[Djordje Radovanovic]

Maybe C10 is to blame.

Djole

[kevin plummer]

when you say hanging is the app frozen or if you look at the sql activity monitor you have threads locked so it freezes your app?

[osquiabro]

Kevin, the webserver continue running but failed when try to connect to sql server, i try to find that causes the problem if NT or C10 sql driver, in c6.3 work perfect.

[osquiabro]

Djordje , maybe C10 is a problem my c10 version is 11726, somebody with this problem?

[kevin plummer]

Is it possible to take your original app (without the new features) and compile using Nt8 and C10 to narrow down if it is C10 or a bug you have introduced? If your glo:dbowner string is wrong or missing then you will get the connect box.

[osquiabro]

Kevin, the system working during the day , i don't when fails, I'm only using the system, the connection string is same that old app, the system is hanging without activities

thanks..

[kevin plummer]

Are you using the native MSSQL driver or the ODBC driver? Do you have the C10 one in your exe folder?

What you are reporting I have read posted here but not for MSSQL but other SQL flavours. You might want to look at those solutions as well.

[osquiabro]

MS Sql Server with native driver

[osquiabro]

in trace a found this error in version compile with c10:

Error Occurred: 08S01 [Microsoft][SQL Native Client]TCP Provider: An existing connection was forcibly closed by the remote host.[Microsoft][SQL Native Client]Communication link failure

TCP Provider: An existing connection was forcibly closed by the remote host.

the version compile in c6 is running perfect.