Thursday, Sep 02, 2010
Login

Posts Tagged ‘C#’

C# Missing References

If you are getting an error like “The type or namespace name does not exist in the namespace” you may have found yourself tweaking the references or the using statements in your C# code. The using statement and the referencing statement differ in that the using statement is a logical link and reference to the [...]


Using properties in an ASP.net Web Control

When creating a web control in an ASP.net application many times you will need to make references to information, data values and other contents of the web control from the web control parent. This is done by adding a Property statement on the control. It could be as simple as a Username and Password control [...]


SMO SQL Server Error Reading Stored Procedures Collection

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 [...]


Oracle Maximum Open Cursors Exceeded

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 [...]


ORA-00911 invalid character

I am using .NET 2005 and the Oracle 10g 10.2 Oracle .NET data framework and I received this error while trying to run a simple statement that is used to find out how many dedicated processes are being used in my Oracle database (“select count(server) as Value, Server from v$session group by server”). Something similar [...]