hallo, this is supposedly my technical blog. probably a junk for you, but i put it necessarily for me since i’m bad at remembering things…
so i write this just as sort of my journal of the technical problem i’ve experienced, in case i stumble upon the same problem in the future.
It’s been several days I looking for connecting crystal report express for visual studio 2008 using sqldatasource, so i can edit the sql query using code behind on runtime. All I found on the net are using dataset or xsd, so more coding required 
But finally I found it in microsoft site, with a few simple steps:
- Create crystal report file.
- Connect to database and add fields on the report, customize it as you like.
Continue reading
OK this is oracle sql error. the first step to trouble shoot it is by spotting what the error said: looks for missing right parenthesis.
But unfortunately, this is not the only case for this error thrown out. Even when we match the count of left and right parenthesis, error ORA-00907 still can be thrown out. some of the cases are:
1. In program, for multi lines sql query, if you put comment it will throw error. ex.
sql = ” select a,round(b,2 –comment “
sql &= ” ) from table “
ok let us start, back early, we know about livedisk, where you can run OS from removable disk, where you dump the OS to the RAM. it was started with linux, but with bartpe windows live cd follows.
then linux introduce the use of usb for both live OS and OS installation, this took several years before we have windows 7/2008 that making installation windows using usb easy. you just need to use these four steps (two is essential):
- makes windows 7/2008 dvd ready in the drive tray.
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
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
for months we were confused by IP address conflict happened with our servers (we are implementing static IP in our LAN). So like usual we were trying to locate what was the culprit. to make it easier for us we just use the portable software netscan. Continue reading
Well microsoft says that it is because they purposely limit the detection mode, so the 48-bit mode is in disable state.
must have SP4 installed first (for XP must have at least sp2 i think).
SAS and SATA are using the same power and data slot. SAS HDD cannot be detected if you plug the SATA cable, but SATA can be detected fine when you plug SAS cable. I haven’t put any though about it until when I installed database on the SATA drive that was plugged to SAS cable. when I imported the data to the database it took all night long to finish then what normally only 30 minutes.
well we just having visited by a technician where my company bough ICA UPS. we got nice info on how to configuring the UPS.
you know if you open the ICA UPS, you’ll see a board right? in that board you’ll see number next to the blue thing that you can turn left or right (like a screw). Continue reading
it happened when my director laptop need to be downgraded to xp. he got sony vaio vgn-sz433n.
so i install the xp pro after downloading all the necessary drives and tools for xp.
everything went smoothly, all driver installed so no more “other devices” showed in device manager.
but when my boss used it he said that the fn key was not working for the projector but it is fine for other functions.
Continue reading
