NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: osquiabro on February 08, 2016, 09:36:33 AM

Title: Webserver Big Problems
Post by: osquiabro on February 08, 2016, 09:36:33 AM

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.

Title: Re: Webserver Big Problems
Post by: Djordje Radovanovic on February 08, 2016, 07:56:54 PM

Maybe C10 is to blame.

Djole

Title: Re: Webserver Big Problems
Post by: kevin plummer on February 08, 2016, 11:05:04 PM

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?

Title: Re: Webserver Big Problems
Post by: osquiabro on February 09, 2016, 02:21:35 AM

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.

Title: Re: Webserver Big Problems
Post by: osquiabro on February 09, 2016, 02:24:33 AM

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

Title: Re: Webserver Big Problems
Post by: kevin plummer on February 09, 2016, 04:12:58 AM

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.

Title: Re: Webserver Big Problems
Post by: osquiabro on February 09, 2016, 06:00:35 AM

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..

Title: Re: Webserver Big Problems
Post by: kevin plummer on February 09, 2016, 05:45:50 PM

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.

Title: Re: Webserver Big Problems
Post by: osquiabro on February 10, 2016, 02:05:41 AM

MS Sql Server with native driver

Title: Re: Webserver Big Problems
Post by: osquiabro on February 17, 2016, 06:41:16 PM

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.