.net sybase executenonquery异常 [英] .net sybase executenonquery exception

问题描述

我正在使用Sybase.Data.ASEClient命名空间从我的asp.net应用程序连接到Sybase DB。随着应用程序的最近的生产版本，我们在DatabaseHelper类中包含一个代码，它只是尝试执行一个ExecuteNonQuery（）。在生产中，说command.ExecuteNonQuery（）的行抛出一个异常，表示

I am connecting to Sybase DB from my asp.net application using Sybase.Data.ASEClient namespace. With the recent production release of the App, we included a code in the DatabaseHelper class which just tries to do an ExecuteNonQuery(). In production the line that says command.ExecuteNonQuery(), was throwing an exception that says

尝试读或写受保护的内存，这通常是一个指示其他内存已损坏。

但这并不一贯。该应用程序工作正常4天，第五天我们突然得到一个用户的错误，然后没有人能够使用该应用程序，当尝试使用涉及数据库访问的功能。

But this does not happen consistently. The application works fine for 4 days and in the fifth day we are suddenly getting this error for a user and then no one else was able to use the application when trying to use the functionality that involved database access.

我也googled并且知道Sybase.Data.ASEClient有一些内存泄漏问题。但是没有关于它是否固定的信息。

I also googled and came to know that Sybase.Data.ASEClient has some memory leak issues. But no information on whether it got fixed or not.

有人可以点亮这个吗？你以前的项目有没有经历过这样的问题？有没有办法用任何方式弄清问题？

Can anyone throw some light on this? have you experienced such issues in your previous projects? And is there a way to figure out the problem by any means?

推荐答案

这听起来像是Sybase驱动程序中的错误。

It certainly sounds like a bug in the Sybase driver.

我将尝试获得Sybase的支持和/或更新版本的驱动程序。 Google不如Sybase支持那样有帮助，因为我相信您需要注册才能在Sybase网站上访问这种信息。

I would try to get support from Sybase and/or a more recent version of the driver. Google isn't as helpful as it could be for Sybase support, as I believe you need to be registered to access this kind of info on the Sybase website.

至于内存泄漏，我记得在过去（2006）的Sybase驱动程序1.1.465.0有内存泄漏 - 这是修复在1.1.516.0。这些是Sybase 12的驱动程序，而且从那以后，事情当然已经发展了很长时间。

As for memory leaks, I remember that in the past (2006) the Sybase driver 1.1.465.0 had memory leaks - this was fixed in 1.1.516.0. These were drivers for Sybase 12 and things have of course evolved a long way since then.

这篇关于.net sybase executenonquery异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！