|
Problem(Abstract) |
Using DataDirect Technologies (formerly known as MERANT)
SequeLink Server, the database connections remain hung after the
application has disconnected. Over a period of time, this causes the
system to freeze. |
|
|
|
Cause |
The problem is with the SequeLink server, where hanging
processes are clearly visible on the SequeLink Console as well as MS SQL
Server Query Analyzer.
There is no problem using the same application with SequeLink Server for
Oracle |
|
|
Resolving the
problem |
Switching from Serverside to Clientside
cursors fixed the problem.
For SequeLink Server 5.1 for Microsoft SQL Server, the SequeLink
Datasource attribute is called DataSourceMSSCursorType. It should
be set to clientside.
1. Launch the SequeLink 5.1 Manager Snapin and navigate to the
datasource.
2. Right click on datasource (Default in this example), select New, then
select Attribute. From the New Attribute windows, select
DataSourceMSSCursorType for Attribute, and select Clientside for the
Value.
3. Click OK
4. Save the configuration
5. Restart the SequeLink service for SQL Server.
|
|
|
|