How do I get Oracle to work with ASP.NET?

I can say that Oracle and .NET is a real pain to get working.  Here are some things that took me a while to learn:

The Oracle Drivers are un-managed

Although Oracle has an xCopy version of the drivers, there are still un-managed pieces of the driver.  What that means, is that you will need to do a full install of the drivers both on your development machine and the server. 

The Oracle Drivers are either 32bit or 64bit

Install the drivers that are appropriate for your web server, either 32 bit or 64 bit.  You will also need to have the app pool for the application set to either 32 bit or 64 bit.   If you don’t, you will receive this dreaded error:

Could not load file or assembly 'Oracle.DataAccess' or one of its dependencies. An attempt was made to load a program with an incorrect format.

Download the Oracle Drivers
Look for the Oracle Data Access Components (ODP.NET) on this link. 
http://www.oracle.com/technology/software/index.html

Driver Reference
Add a reference to the Oracle.DataAccess
Check if the references if the Oracle.DataAccess is marked to Copy local.

Visual Studio 2010 and earlier have 32 bit Casini

When you run the web application inside Visual Studio, the default web server built into Visual Studio is called Casini.  It is 32 bit.  So although you may have a 64 bit machine and 64 bit drivers, Oracle will not run in Visual Studio unless you get the 64 bit Casini version.  Visual Studio 2012 and higher has a Casini that is 64 bit.  It is interesting to note that any MSTest or NUnit tests will be run in 64 bit mode so any integration tests will work. 

http://cassinidev.codeplex.com/

How to use Teradata with .NET

I recently worked on a fairly complex report which pulled data from three different systems.  One of the databases used Teradata.

How to use Teradata with .NET

1.  Download the .NET driver:
 http://downloads.teradata.com/download/connectivity/net-data-provider-for-teradata

2.  Add a reference to both  Teradata.Client.Provider.dll and the Teradata.Net.Security.Tdgss.dll in your Visual Studio Project

3.  Create a connection string in the web or app.config.  Here is the format:
http://www.connectionstrings.com/teradata/

  


4.  Write some code to connect.
Example:

using Teradata.Client.Provider;

public class Repository
{
    public void TestConnection()
    {
        TdConnection conn = new TdConnection
        {
            ConnectionString = ConfigurationManager.ConnectionStrings["MyDatabase"].ToString()
        };
        conn.Open();
    }
}

Questions

Q:  In order to use Teradata with .NET, do I need to do a full install of the drivers on the web server or do I just need Teradata.Client.Provider.dll and the Teradata.Net.Security.Tdgss.dll?

A:  I found this out by trial.  The Teradata driver does not reference any unmanaged pieces so it can be xcopy deployed to the bin directory on your web server.




Q:  Why am I getting the error:  [Teradata Database] [8017] The UserId, Password or Account is invalid.
A:  Put this in your web.config: 

 


Q:  When am I getting this error:  The NTLM authentication token is not supported
A:  I don't know why.  I had to switch from integrated security to a normal user name and password.

Sogeti, there is simply no comparison...

I always get a good chuckle when I receive the recruiter spam from linked in or calls from other companies asking me to come and work for them.  The grass isn't greener; no matter how many times a day Kaleb Dumont sends me an email.  Sogeti simply has better opportunities and better benefits.  I have many years before I reach retirement.  I figured it out this past weekend that I will be able to retire earlier because of the high 401K matching that Sogeti is doing.  Here is a theoretical example of how a salary would compare for a developer at another company vs. the same salary at Sogeti:

Item	Other Company	Sogeti	Notes
Example Base Salary	$50,000.00	$50,000.00
401K Match	$1,500.00	$4,500.00	Sogeti matches $1.50 per $1.00 up to 6%. Typical companies match up to 3%.
Profit Sharing	$-	$2,500.00	5% profit sharing also goes into the 401K
Individual Bonus Program	$-	$2,500.00	$2,500 is the minimum if you are billable for a year
Laptop	$-	$1,500.00	Dell Lattitude
MSDN Universal Subscription	$-	$10,000.00	Architect Edition of Visual Studio
Effective Salary	$51,500.00	$71,000.00

Also, the health insurance has no monthly payments.  It is an HSA with a high deductible.  If you are not sick that often, it is a great benefit.  Try plugging in your salary and see what you come up with.  I would bet you that Sogeti comes out on top.  Contact me if you are interested in joining Sogeti.

Sogeti Comparison

Samuel Kenneth Finzer Update 81

I haven't had an update for my son Samuel in a really long time.  I thought it would be good to share how he is doing.  Samuel has completely caught up with major motor skills and fine motor skills.  He had a lot of problems jumping at first but now he is jumping everywhere.  Samuel's current hurdle is speech.  This is due to having a feeding tube down his throat for the first year and also the fact that he was exhausted from breathing with the one normal lung and one lung 1/3 the size.  He puked and slept a lot that first year.  Samuel recently had a full neurological evaluation.  Praise the Lord he is now in the average range for speech.  Samuel continues to be in speech therapy, mainly for mom's comfort now.  Samuel attended preschool a couple times a week this past year so that he could continue to learn.  Soon, Samuel will be attending a pre-kindergarden class all week.

We are feeling now that we are finally on the last hurdle.  Last year Samuel had his tonsils out.  The big tonsils were hereditary and not related to Samuel's CDH (Congenital Diaphragmatic Hernia).  Jasmine had her tonsils out as well.  The tonsils were so large that Samuel only had room to swallow food the size of a pea.  If we would not cut up food small enough, the food would get stuck and he would puke out his entire meal and then not eat anything.  It was typical last year that he would puke at least one meal.  Now that his tonsils are out we were hoping that it would be easier to get him to eat.  He is still prone to puking, although now it is more a mental thing rather than having enough space in the back of his throat issue.  It is heartbreaking to Leyla because she creates meals with such great care to try and get Samuel to eat.  If you could pray for Samuel, ask that God would give Samuel the ability to chew and swallow properly so that he can continue to grow.  Samuel is 83 percentile in height and 24 percentile in weight.  He is a stick.  Samuel introduces himself to other boys as "I'm the fastest runner"  Whatever food he does eat he burns off because like all boys, Samuel likes to run and climb.

Personally, I am hoping that we are at the end of the financial distress from all the medical bills.  Since Samuel has been born we have spent $6000 to $10,000 per year in medical bills (this is our portion after insurance).  In addition to all that Samuel went through, Leyla's body was wrecked by the pregnancy.  She had to go to a chiropractor and her thyroid needed to come out because it was over producing.  That was an expensive surgery.  The speech therapy is not covered by insurance and it was $500/month.  I fought with the insurance company for several months to try and get them to pay.  Basically, they do not pay because the speech is not affected by the mouth (split tongue, cleft pallet, cleft lip etc).  We have a cheaper option now for the speech therapy.  We still owe Nationwide Children's hospital around $3000.  God willing we are hoping to pay it off this year.     

I love all my kids, and I am thankful to God for all of them.  However, when I get a hug from my son, it puts me in remembrance of how thankful I am to have him.  Samuel could have be in heaven now instead of having him be a blessing to us.  He is full of personality, like most boys cracking jokes with potty humor.  He loves remote control cars and trucks.  He also likes airplanes and helicopters.  I bought him a blue tricycle this summer and that boy rides that thing everywhere.  I thank all of you for your prayers and your love.      

My favorite .NET Tools

I have a Java friend that just asked me.  What are your favorite .NET tools?  Here they are.

Resharper. This is a must.  It makes it so easy to navigate, refactor, and run tests. 
http://www.jetbrains.com/resharper/

My favorite coverage tool:
http://www.jetbrains.com/dotcover/

My favorite profilers:
http://www.jetbrains.com/profiler/
http://www.eqatec.com/Profiler/

Incredible code translation from VB.NET to C# or C# to VB.NET
http://www.tangiblesoftwaresolutions.com/Product_Details/Instant_VB.html
http://www.tangiblesoftwaresolutions.com/Product_Details/Instant_CSharp.html

Beyond compare works great with subversion and TFS for code merging:
http://www.scootersoftware.com/

If you are using subversion, this tool is a must for Visual Studio:
http://www.visualsvn.com/

This is a great tool for creating database documentation:
http://www.dbdesc.com/

My favorite .NET regular expression editor:
http://www.ultrapico.com/Expresso.htm

My favorite Obfuscator:
http://www.deepseaobfuscator.com/

My favorite .NET Help file creator:
http://www.innovasys.com/products/dx/

My favorite Installer Creator:
http://www.installaware.com/

This is my favorite decompiler right now. 
http://ilspy.net/

My favorite training site:
http://www.pluralsight.com

If you are just getting started with .NET, this may help:
http://www.learnvisualstudio.net/

Some of my favorite quick reference sheets for .NET:
http://www.addedbytes.com/cheat-sheets/
http://refcardz.dzone.com/

Other favorites not .NET related.

My favorite notepad replacement:
http://notepad-plus-plus.org/





My favorite paint replacement.
http://download-paint-net.com/

My favorite windows explorer replacement:
http://www.gpsoft.com.au/

My favorite link checker:
http://home.snafu.de/tilman/xenulink.html

My favorite directory size tool:
http://www.jam-software.com/treesize_free/

My favorite way to run applications on my USB Flash Drive:
http://portableapps.com/

My favorite corporate wiki:
http://www.screwturn.eu/

My favorite personal wiki:
http://tiddlywiki.com/

My favorite FTP and SFTP software:
https://filezilla-project.org/

My favorite Zip Software:
http://www.7-zip.org/

My favorite PDF printer:
http://www.cutepdf.com/

My favorite ISO mounter:
http://www.slysoft.com/en/virtual-clonedrive.html

My favorite cross database editors:
http://www.razorsql.com/
http://www.sqlmaestro.com/products/anysql/maestro/

My favorite online backup:
http://www.backblaze.com/