One day Drive in Shikaripura Taluk - Anjanapura and Balligavi

It was Vijayadashami Holidays of 2017 and my fridnd Aravind LH was there with us, with his family.  We enjoyed the Shivamogga Vijayadashami procession, remembering our college days.

As we had one day to spare, we decided to roam around nearby places which we have not covered at all.  We planned to visit Anjanapura Dam and Balligavi, which were in Shikaripura Taluk.

We finished our breakfast at our home and started our journey by 11 AM to Anjanapura Dam.  There are two routes to reach Anjanapura.  One is Shivamogga - Savalanga - Harogoppa - Anjanapura - drive about 50 km from Shivamogga and take right at Anjanapura Dam Cross junction and from there 7 km drive to reach the Dam.
Second route is via Shivamogga - Ayanur - Choradi - Kalmane - Anjanapura. Both routes have a good road condition till the Dam Site.

We packed some lunch at Shivamogga and reached the Dam site at around 12.30.

As there was good amount of rain in the previous weeks, the dam was filled to its capacity and some gates were opened to maintain the water levels.

 This is dam is constructed for providing water for agricultural use.  There are lots of paddy cultivation in the area which will benefit from the Dam Water.

We walked to the base of the outflow, which is a secure place to play in water. Kedar enjoyed playing in water.

We had our lunch on the banks of dam back-water.  The spot is very nice and scenic.  Kids really enjoyed the place.

The Backwater of the Anjanapura Dam.

After finishing our lunch, we started towards Belligavi. Balligavi is situated at 39 km from Shikaripura towards Shiralakoppa. As it was still raining on the way, we really had a pleasures drive in the hot Shikaripura region.

Balligavi is famous for its Kedarashwara Temple which was built by Hoysala's in 12th Century. The temple architecture is very good.  We can find the 'Hoy -sala' ('Sala', kill the tiger") emblem on the roof top of the temple. 

Temple Entrance

The Grand Nandi

( Hoy-sala) ಹೊಯ್ಸಳ  ಲಾಂಛನ 

At around 4.30 pm we started our journey back to Shivamogga. On the way, we paid a visit to "Sri Huchhuraya swamy" Temple a temple of Anjaneya at Shikaripura Town.

It is a practice with many devotees of Anjaneya to Visit his three most powerful temples in Karnataka. They are 1. Bhrantesha - Shikaripura , 2. Kantesha - Kadaramandalagi and 3. Shantesha  - Satenahalli. It is believed that darshan at three temples in a single day is very holistic and one can receive blessings in abundance.

Here is the route map for the above three temple visits.

Guide map for Three-Anjayana  darshan.

There was a heavy, a very heavy rain awaiting us on the way back to shivamogga.  We drove safely to shivamogga with good memories of Shikaripura Taluk.

Visual Studio 2008 Deployment project.. Could not create .tmp file.. Access Denied

Project deployment under Visual Studio is quite a simple task, but not this time.
I had a weird error saying ' Could not create c:\prog~1\Local~1\Temp\vs09EBC.tmp'

As usual, tried all possible self determined alternates but nothing worked and after googling for nearly an hour.. the reason found to be my Kaspersky Internet Security !!! Strange..

Its was the Antivirus, Kaspersky Internet Security which was behind this error generation., the solution...
Just pause the realtime protection for few min .., say 3 min. and compile... Bingo..

Thanks for the original poster.. but thought to share it as some may solve it easily...

Keep programming, keep blogging :)

Reading Excel from .NET

Often we need to implement reading an Excel workbook via .net applications and because of the ADO.NET advantages, it seems quite an easy task.

Just create a connection string, create a data reader or a Data table and read your excel sheet .!!

Your connection should be something similar to

cnStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & yourfilename & ";Extended Properties=""Excel 8.0;"

But, the main problem is when your Excel sheet contains columns, which are mixed, i.e. your columns values have Numbers and Text both.

In this situation, just by adding IMEX=1 in your connection string , should make life easier.

cn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & strServerFileName & ";Extended Properties=""Excel 8.0;IMEX=1"""

Please note that the Extended Properties value is enclosed in quotes.

What happens by using IMEX=1 is, this option tells the connection to honor the registry value ImportMixedTypes = Text, located at HKLM\Software\Microsoft\Jet\4.0\Engines\Excel\

Again if, in some situations, you are supposed to read number from a column and the first few values in the column, say about 10-15 cells are empty, then we face the evil. :)

This is because, when deciding the data type of each and every column, the system will check for the registry key HKLM\Software\Microsoft\Jet\4.0\Engines\Excel\TypeGuessRows

If the the TypeGuessRows value is, say, 8, and the column's First 10 values are Null, then the column all the values from that column is treated as Null, when everything seems perfect !!!.

So, if you are not getting the values from Excel, first and foremost thing to check and change is the HKLM\Software\Microsoft\Jet\4.0\Engines\Excel\TypeGuessRows value.

Change the TypeGuessRows value as per your requirement and TypeGuessRows value = 0 means all 64465 cells to be scanned before deciding the DataType of the Column.

Hope this helps someone at sometime.. :)

Cheers , Happy coding...

Hemanth Kelkar