Varad, The .NET Guy!

Exploring the excitement of Microsoft .NET and much more..
.NET Rocks - Great Source for all of us!

Thanks very much to Carl Franklin and Richard Chambell for bringing this valuable resource to everyone's desktop.

.NET Rocks is one of the important / more useful resource for all IT savvy to know more about the .NET Technology and software development in general.

There are around 177 shows currently, all are much valuable and contains rich information about the technology. I already subscribed to the shows and downloaded each. Its good to spend enough time everyday by listening to each show and get to know the insights. Very nice!

Check out the official .NET Rocks site and subscribe to it (if not done already). 

 

Posted: Sep 10 2006, 01:13 PM by Varad | with no comments
Filed under:
Visual Studio 2003 Service Pack 1 Now Available

After 3 years of its release, a service pack for Visual Studio 2003 is made available by Microsoft on 8/17/06.

More Info:

List of bugs that are fixed in Visual Studio .NET 2003 Service Pack 1

Visual Studio .NET 2003 Service Pack 1 release notes

Check out Microsoft Servicing site for information about other service releases of MS Products.

 

Posted: Sep 07 2006, 10:17 PM by Varad | with 1 comment(s)
Filed under:
Timeout Expired - Max Connection Pool

We are using Enterpise Library June 2005 relase for .NET Framework 1.1 in our application, having a Oracle 10g database.

We are getting the following error often,

 ===============================================================================================================

Message : Timeout expired.  The timeout period elapsed prior to obtaining a connection from the pool.  This may have occurred because all pooled connections were in use and max pool size was reached.

Source : System.Data.OracleClient

Help link :

TargetSite : System.Data.OracleClient.OracleInternalConnection GetPooledConnection(System.String, System.Data.OracleClient.OracleConnectionString, System.Data.OracleClient.OracleConnection, Boolean ByRef)

Stack Trace :    at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction)

   at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact)

   at System.Data.OracleClient.OracleConnection.Open()

   at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState)

   at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)

   at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)

   at Microsoft.Practices.EnterpriseLibrary.Data.Database.DoLoadDataSet(DBCommandWrapper command, DataSet dataSet, String[] tableNames)

   at Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(DBCommandWrapper command, DataSet dataSet, String[] tableNames)

   at Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase.LoadDataSet(DBCommandWrapper commandWrapper, DataSet dataSet, String[] tableNames)

   at Microsoft.Practices.EnterpriseLibrary.Data.Database.LoadDataSet(DBCommandWrapper command, DataSet dataSet, String tableName)

   at Microsoft.Practices.EnterpriseLibrary.Data.Database.ExecuteDataSet(DBCommandWrapper command)

   at Microsoft.Practices.EnterpriseLibrary.Data.Oracle.OracleDatabase.ExecuteDataSet(DBCommandWrapper commandWrapper)

 ===============================================================================================================

As per the Enterprise Library documentation and expert reviews (ref. MSDN Magazine Data Points) it was mentioned as,

The DAAB also helps manage connection state for you. For example, if you want to fill a DataSet or insert some rows by executing a stored procedure, the DAAB automatically opens and closes the connection when needed. It uses the open late, close early approach so that connection pooling is maximized.

We are using only ExecuteDataset and ExecuteNonQuery in our Business Layer. But not sure why this error is occuring on the server.

When we contacted our DBA it was told that "There were two listeners running".

We are pretty sure that there is no connections kept open in our application, since its been taken care by the DAAB.

Not sure what was the cause for this problem.

Did anyone encountered similar issue? Is there some settings to be done on the DB Server?

All inputs are very much appreciated.

Thanks!

Update 08/21:

This has been resolved.

At times, there were 2 listeners getting created in our DB, This causes slow performance in application and sometimes throws time-out error as well.

We were told that there was a reference to an Oracle bug #4518443, Oracle reported this bug on metalink and has given a patch for the fix.
After installing this patch p4518443_10201_AIX64-5L.zip from metalink for AIX system, the issue of spawning 2 listeres got resolved.

This is a problem only in Oracle 10g.

 

Posted: Aug 07 2006, 01:32 PM by Varad | with 1 comment(s)
Filed under:
The IT Profession - 2010

Read the computer world's recent special report on IT field in next four years.

http://www.computerworld.com/action/article.do?command=viewArticleTOC&articleId=112367

 

Posted: Jul 29 2006, 07:53 PM by Varad | with no comments
Filed under:
Free Download: MSDN Library May 2006 Edition

This is definitely a good news for all MS developers. 

Check out the news at Rob Caron's Blog

Download MSDN Library May 2006 Edition here

 

Posted: Jul 26 2006, 10:53 PM by Varad | with no comments
Filed under:
New Oracle Data Provider for .NET 2.0 [ODP.NET]

I just got this over e-mail and keeping it here for reference.

The new version of ODP.NET is released by Oracle Corporation, the download is available here 

The features include the following:

    ODP.NET -- ADO.NET 2.0 Support
    • Factory and DbCommon Classes
    • Connection String Builder
    • DataAdapter Batch Processing
    • Schema Discovery
    • Server Enumeration

    Oracle Developer Tools (ODT) for Visual Studio .NET
    • Visual Studio 2005 Integration
    • Integrated PL/SQL Debugging (Visual Studio 2003 and 2005)

    Oracle Database Extensions for .NET
    • .NET 2.0 Framework Support

Additional resources:

  • Learn some ODP.NET best practices to optimize your .NET application's performance.
  • Oracle Developer Tools for Visual Studio 2005 Demo
  • .NET Stored Procedures Demo

 

Posted: Jul 20 2006, 09:56 PM by Varad | with no comments
Filed under:
LINQ and more..

Language-Integrated Query (LINQ) is a technology that eliminates the mismatch among different data domains.  With LINQ, there is no need to learn separate query syntaxes when querying over diverse data domains such as XML, Relational and Objects.

Check out the MSDN Channel9 Session on LINQ.

More information is available at The LINQ project site.

Blinq is one of the exciting tool for ASP.NET and SQL. Looks like its better use Blinq for creating Admin modules to manage the Master Tables in an application database. Its very simple to create web pages without any code and it all happens just linking the SQL Database to the tool. Wonderful!

ScottGu's excellent blog post on Using LINQ with ASP.NET Part I and Part II is worth a read and practice.

 

Posted: Jul 16 2006, 12:00 PM by Varad | with no comments
Filed under: , ,
.NET Framework 3.0, It's (Beta) arrived!

James has just posted these links. Keeping it here for self reference [I]

And here are some additions

Posted: Jul 12 2006, 10:21 PM by Varad | with no comments
Filed under:
TD.NET Enterprise and Professional Version!

Today's HOT Topic in .NET Blogsphere is that TestDriven.NET of Jamie goes commercial.

We have been using his TD.NET extensively in most of our projects and are amazed with its features. It is AWESOME!

Read more here TestDriven.NET Enterprise & Professional

I will go for the personal edition quickly and need to follow-up with my BOSS on getting the Enterprise version :)

I still remember the day Jamie helped us (over mail) on resolving an issue we had with NUnit & NCover while generating a coverage report. We always appreciate his time in bringing this product a remarkable one among all .NET Developers!

Thanks a lot to Jamie. All the very best to TD.NET Commercial Versions!

 

Posted: Jul 10 2006, 09:05 PM by Varad | with no comments
Filed under:
Microsoft CodePlex

Microsoft Launches CodePlex, Vehicle for Sharing Source Code.

Read more here

Posted: Jul 08 2006, 06:19 PM by Varad | with no comments
Filed under:
More Posts Next page »