Data not getting updated in a SQL Server 2000 database in an ASP.Net application

jarathna · 04-26-2007, 06:56 AM

Hi
I have a peculiar problem
I have a web application hosted on a web server and a database with SQL Server 2000. With this application all are able to insert and update data

One person is having a problem. She is able to insert data but not update the data. This is happening on her machine. However when she logs on in her partners machine and access this site she is able to both insert and update data.

We tried uninstalling and installing IE 6.0.28 SP1 and tried. But no luck. We tried rebooting her machine and trying out afterwards. No luck.

Both the client machines are running Windows 2000 Professional. The applications is a ASP.Net vb web application running on IIS 6 with Windows 2003 Os. The insert and update logic is in a stored procedure.

No other person is having this problem. The web site has about 1000 odd users.

Would appreciate your help.

**gamerman0203** · 04-26-2007, 11:03 AM

Has the client machine been updated recently? I'm unfamiliar with if MS is still providing updates for 2000. Also, what about .Net framework on the clients machine? Is this needed? I'm not up to speed on ASP.NET so I'm not sure what it requires, but obviously it's something isolated to just that one machine.

jarathna · 04-27-2007, 08:20 AM

Hi
Thanks for your suggestion which made us look at the operating system level for this problem. The problem is solved now. The issue was a vb script function was called in a java script and threw an error. The reason for this error was that the vbscript.dll was corrupted. We copied it newly and re registered it again. BOOOM!!!! Everything works fine now.
Thanks

**DJ-Zep** · 04-28-2007, 07:59 PM

Glad to hear you found a solution.

04-26-2007, 06:56 AM	#1 (permalink)
jarathna Registered User Join Date: Apr 2007 Posts: 2 OS: Windows 2000 Professional	Data not getting updated in a SQL Server 2000 database in an ASP.Net application Hi I have a peculiar problem I have a web application hosted on a web server and a database with SQL Server 2000. With this application all are able to insert and update data One person is having a problem. She is able to insert data but not update the data. This is happening on her machine. However when she logs on in her partners machine and access this site she is able to both insert and update data. We tried uninstalling and installing IE 6.0.28 SP1 and tried. But no luck. We tried rebooting her machine and trying out afterwards. No luck. Both the client machines are running Windows 2000 Professional. The applications is a ASP.Net vb web application running on IIS 6 with Windows 2003 Os. The insert and update logic is in a stored procedure. No other person is having this problem. The web site has about 1000 odd users. Would appreciate your help.

04-26-2007, 11:03 AM	#2 (permalink)
gamerman0203 Retired Join Date: Oct 2005 Location: Grand Rapids, MI Posts: 2,144 OS: XP MCE, Ubuntu Gutsy My System	Re: Data not getting updated in a SQL Server 2000 database in an ASP.Net application Has the client machine been updated recently? I'm unfamiliar with if MS is still providing updates for 2000. Also, what about .Net framework on the clients machine? Is this needed? I'm not up to speed on ASP.NET so I'm not sure what it requires, but obviously it's something isolated to just that one machine. __________________ Follow These Steps First! CPU-Z \| SensorView \| WinXP Clean Boot \| Latest DirectX \| ATI Catalyst \| Nvidia ForceWare Posting System Specifications

04-27-2007, 08:20 AM	#3 (permalink)
jarathna Registered User Join Date: Apr 2007 Posts: 2 OS: Windows 2000 Professional	Re: Data not getting updated in a SQL Server 2000 database in an ASP.Net application Hi Thanks for your suggestion which made us look at the operating system level for this problem. The problem is solved now. The issue was a vb script function was called in a java script and threw an error. The reason for this error was that the vbscript.dll was corrupted. We copied it newly and re registered it again. BOOOM!!!! Everything works fine now. Thanks

04-28-2007, 07:59 PM	#4 (permalink)
DJ-Zep Design Team Join Date: Mar 2006 Location: Philadelphia Posts: 1,541 OS: Windows Vista Home Premium (x64) My System	Re: Data not getting updated in a SQL Server 2000 database in an ASP.Net application Glad to hear you found a solution. __________________ Nice music blog Nvu \|\| Notepad++ \|\| Apache \|\| PHP \|\| Keep TSF Alive "The great thing about a computer notebook is that no matter how much you stuff into it, it doesn't get bigger or heavier."