sybase ado driver dll open connection locked.

[Wei Lu]

Hi,

Our website is using the sybase database and we use the ASE ado.net provider
to connect to the sybase DB. Sometime the website hang and we finally found
that one thread is locked on the method of open connection for sybase DB.
The windbg clr call stack shows that the thread is waiting on the
Sybase.Data.AseClient.Unmanaged.OpenConnection() method which call the
sybdrvado11.dll ( which is a unmanaged dll ) to open the connection.

Does anyone know why this issue happen? Or any tool could help me to check
what is going on and which is the thread waiting for?

Wei Lu

 

[Colbert Zhou [MSFT]]

Hello Wei,

For this issue is about ASE provider for Sybase database driver, I highly
recommend you also try to contact the Sybase support entrance or post in
the sybase.public.connectivity.adonet and sybase.public.chinese.ase.general
newsgroup,
http://www.sybase.com/support
http://groups.google.com/group/sybase.public.connectivity.adonet/topics?lnk
http://forums.sybase.com/cgi-bin/webnews.cgi?cmd=listitems&sort_on=none&seco
nd_sort=date&sort_method=date&sort_reverse=true&group=sybase%2Epublic%2Echin
ese%2Ease%2Egeneral

A quick research on the web turned out a known issue which looks similar as
your one. See the 5.1 section,
http://infocenter.sybase.com/help/topic/com.sybase.dc75882_1500/pdf/rb_win_Z
H.pdf?noframes=true
It is related to the size of sp_configure and SSL.

Hope it helps and have a nice day, Wei Lu!

Best regards,
Colbert Zhou ([email protected], remove 'online.')
Microsoft Online Community Support

Delighting our customers is our #1 priority. We welcome your comments and
suggestions about how we can improve the support we provide to you. Please
feel free to let my manager know what you think of the level of service
provided. You can send feedback directly to my manager at:
(e-mail address removed).