Category: Database
Saturday, 8 November 2008 11:53
The following error is appearing while running Visual Studio 2005 and developing an application with SMO capabilities. It appears when trying perform a foreach( on ActiveDB.StoredProcedures). Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or one of its dependencies. An attempt was made to load a program with an incorrect format. I found [...]
Wednesday, 15 October 2008 14:43
Error “ORA-01033 ORACLE initialization or shutdown in progress” plagued me twice, not a third, unprepared! Since this was the second time this happened to me so I decided I should get all my ducks in a row cause if it happened twice, it will most likely happen a third time, if not to me, then [...]
Wednesday, 1 October 2008 11:20
Ewwwh, this was a nasty little bug. Let me describe the title … I was having to update all our database data and schema to support the GMT/UTC baseline and then accounts and clients would register what timezone they are in and our system would reflect the dates and times from GMT/UTC to the registered [...]
Friday, 19 September 2008 20:15
Searching for a document that helps to connect a .NET web application with MySQL is hard to find. So, I thought I would provide instructions I put together while developing my own applications. The .NET infrastructure is very flexible and is easier to use than people think. Here are the steps that I went through [...]
Wednesday, 21 May 2008 14:33
In writing my application that checks certain settings and values every few seconds received the following error today. ORA-01000: maximum open cursors This error presented itself because I wasn’t closing the OracleDataReader object in my code. I’ll show below the entire code and then bold the code that I had to add to rid my [...]