Posts

Showing posts from 2013

HealthCare.Gov Experience

I have options and I wanted to check out prices and sort of verify a lot of noise around HealthCare.Gov site. My first try to create a Market Place account at Healthcare.gov failed with a message "Important: Your account couldn't be created at this time. The system is unavailable." and a link to "Try Again". We have seen huge advancements and proven examples in the arena of Big Data management, heavy traffic routing, load balancing, and many other behind the scene IT/business activities that occur to produce Google, Facebook, Yahoo, amazon, Ebay and many other sites. We just don't expect these sort of failures from a web site that has been in the making for over three years. Everybody knew or should have known that the site will be hit by millions simultaneously. No surprise there. Surprise is that the site is failing. The chat functionality (available in the site) with a live agent worked fine. The phone call (listen on the site) with a live agent...

NOCRMUG becomes OCRMUG

We've had a good run at keeping our little group to ourselves. We've enjoyed our favorable odds of winning our raffle draws in meetings of NorthEast Oklahoma CRM User Group. But we all have been wanting to increase our exposure to other folks in Oklahoma. So, after discussing with some of the regulars, I have decided to make our group a local chapter of a much larger national organization, Microsoft dynamics CRM User Group (CRMUG). This will boost our marketing effort of events, help us us get additional presenters, and last but not the least, get more goodies for additional sponsors. So, our new Organization is Oklahoma CRM User Group (OCRMUG). this month's meeting announcement at CRMUG web site. http://www.crmug.com/events/ crmugok103013?date

Do Identity Insert in Oracle table

How do you do Identity Insert in Oracle? I am one of those poor souls that work in both microsoft SQL Server and Oracle and don't have the luxury of complaining about either one. Identity Insert is something I always have used in when designing tables in Microsoft SQL server. I won't get into the argument of why we need it or should we even use it. Rather, this article is about achieving the same. Oracle does not have any numeric Identity Insertion capability out of the box. Well, good old Sequence can come to the rescue. Create a sequence for your table/purpose or even for all purposes. then create a trigger ON INSERT to get the next value from the sequence and update your table. Voila, you got yourself an Identity Insert Column in oracle

Parameterized OleDb Command for Oracle to execute in C#

Recently, when writing into an oracle database from C# using  OleDbConnection I kept running into some of the gibberish errors that Oracle keeps throwing. My Insert Query looks something like this,  "INSERT INTO TableA (Col1, Col2, Col3) Values ?, ?, ?;" Just in case anybody is wondering, the adding Question marks is the way to parameterize oracle queries for C#/VB. First strange error I kept getting was  ORA-00947 not enough values. I kept counting my columns and values and just did not seem incorrect. Of course then I noticed my all important parenthesis that are missing. so, my query is now changed to " INSERT INTO TableA (Col1, Col2, Col3) Values (?, ?, ?);" Onto adding the OleDbParameters with Values to the Parameter Collection and Voila, my codes start working. So much for these errors Oracle throws that makes very little sense.