DevForce Community Forum : Access to database server blocks

DevForce Community Forum : Access to database server blocks http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Access to database server blocks Wed, 29 Jul 2026 17:50:30 -700 Fri, 25 Mar 2011 11:00:03 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2582 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Access to database server blocks : Yes, I apologize. I meant to say... http://www.ideablade.com/forum/forum_posts.asp?TID=2582&PID=10291#10291 Author: DenisK
Subject: 2582
Posted: 25-Mar-2011 at 11:00am

Yes, I apologize. I meant to say the Informix equivalent of clearing the connection pool. As of this moment, that is the best advice I can give.

DevForce does no direct database access. Everything is through the Entity Framework. We open and close the connection to the Entity Framework with each query and save request. There have been no reports of this problem with other databases.

I suspect that the problem is between the Entity Framework provider and the database. Have you tried posting the questions to the Informix guys?

]]> Fri, 25 Mar 2011 11:00:03 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2582&PID=10291#10291 Access to database server blocks : From the Microsoft documentati... http://www.ideablade.com/forum/forum_posts.asp?TID=2582&PID=10288#10288 Author: tj62
Subject: 2582
Posted: 25-Mar-2011 at 8:43am

From the Microsoft documentation:
The System.Data.SqlClient namespace is the.NET Framework Data Provider for SQL Server.

So this is available for SQL Server only.

Even though we had such functionalety for the IBM data provider (it might exist, I don't know) then it would not help as, the connection is hung even if I restart Visual Studio and restart it again. The only way to get it running again is to restart the whole database server.

]]> Fri, 25 Mar 2011 08:43:11 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2582&PID=10288#10288 Access to database server blocks : Hi tj62;This sounds like something... http://www.ideablade.com/forum/forum_posts.asp?TID=2582&PID=10280#10280 Author: DenisK
Subject: 2582
Posted: 24-Mar-2011 at 8:00pm

Hi tj62;

This sounds like something is holding on to the connection pool. Have you tried resetting them by calling System.Data.SqlClient.SqlConnection.ClearAllPools() ?

]]> Thu, 24 Mar 2011 20:00:39 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2582&PID=10280#10280 Access to database server blocks : One important thing I forgot.... http://www.ideablade.com/forum/forum_posts.asp?TID=2582&PID=10273#10273 Author: tj62
Subject: 2582
Posted: 24-Mar-2011 at 5:25am

One important thing I forgot. When this happens and I try to login the next time (without restarting the database server). This is the InnerException:

"The underlying provider failed on Open."

We are using IBM Data Provider beta, that has revealed to be rock stable until this problem started.

]]> Thu, 24 Mar 2011 05:25:35 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2582&PID=10273#10273 Access to database server blocks : Hi,We are using DevForce 6.0.9... http://www.ideablade.com/forum/forum_posts.asp?TID=2582&PID=10272#10272 Author: tj62
Subject: 2582
Posted: 24-Mar-2011 at 5:17am

Hi,

We are using DevForce 6.0.9 and INformix Dynamic Server 11.7.

First of all when version 6.0.7 came we where forced to do this to get it working:

TransactionSettings.Default = new TransactionSettings (System.Transactions.IsolationLevel.ReadCommitted, new TimeSpan(0, 1, 0), false);

If we set the last parameter to true all queries timed out. However the above workaround seemd to work untill we upgraded our database server from version 11.5 to 11.7. After that we get very misterious errors in between:

After running our Silverlight app. a few times (arbitrary) all queries start to hang "for ever". The only way to get it running again is to restart the Informix database engine. It is not enough to restart the Visual Studio Development web server. However as this is true we do not see anything wrong with the databas server. Other applictions can logon via ODBC or native Informix to the databas server and we can query the database, update, insert just as usulay. It is only the Silvelight application that seems to somehow be totally blocked to enter. Investigating Informix sessions, log files etc. does not reveal anything abnormal.

Any idea what might be causing this?

Regards

]]> Thu, 24 Mar 2011 05:17:27 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2582&PID=10272#10272