oracle error ora-01033 : ORACLE initialization or shutdown in progress

Ok i have this error on my oracle 8.1.7 database with oracle developer 6i R2.
This usually happened when the computer is improperly shutdown like of power failure or BSOD.
Been searching on the internet most of the solution is to connect straight to sqlplus, like this:

– open the command prompt.
– in “c:\>”, type “sqlplus /nolog”
– in “sql>” type connect / as sysdba

Now this is the problem, based on the tutorial it should generate “connected” status, even though i’ve tried using the proper form of “connect sys/manager as sysdba” it still generating TNS error.
Continue reading

ASP.NET 2008 BOUND FIELD LIMITATION

just find out today, another limitation of the visual studio 2008 asp.net.
beside it somehow not 100% compatible with early days oracle query (I use oracle 8.1.7 database with asp.net 2.0/vs2008, ans some queries just cannot work without “simplifying” it).

anyway, back to the tittle, it seems that every time i make it over 127 columns when i save it, the visual studio crashed (actually i can save it at 127 columns, but when i add 13 more bound fields, it crashed). the strange thing is that it is ok if you use automatic generating field option, but not ok if you manually add the field yourself…

but don’t worry there is a work around to that, but this is with a consequence,
Continue reading