I have just started a new project, where I feel as though I have been transported back in time several years. The project is using Visual Basic 6, Oracle 9i using a two tier approach, all of the buisness logic sits in the database hidden inside hundreds of stored procedures, and the Visual Basic Code is well, visual Basic. I say this after several projects where I have been using .Net and N-Tier approaches to application archetecture and development, so have become accustomed to a more sophisticated approach to application development.
There are changes a foot, i.e. converting the VB Code base to C# and cleaning up the database access layer, so that much of the code will be replaced with ADO.Net, reducing the code base significantly, as far as the Oracle database, not sure what will be done there yet.
More to come