Recent content by bobhagan

I am translating a group of reports from CR.8.0 to CR.NET. Several use ... AND {STATUS.STATUS_DT} >= {?StartDt} AND {STATUS.STATUS_DT} <= {?EndDt} in the query. In the CR8 version the query returns data from the day of EndDt. The CR.Net version returns only up to the day BEFORE; as if the...

Santa I installed a new drive, and still wasn't able to get my backup to work. Intelligent Agent stopped crashing, but when I followed your steps, I got exactly the same errors. I found pieces of the stored procs that I thought I had lost. After that, it just wasn't worth trying to recover...

<the rural mail man delivered one copy to every house in the county> Wow. I guess we're not in Kansas. <several XPSP2 ppl that are using/running SATA> Yeah. That's what's really strange - I had no trouble setting up the original drive. Thanks again for the help. Bob Hagan

Well... Computer stores are selling XP upgrades w/SP2 for $89.95. From reading more about slipstreaming I realized that the network install SP2 was actually a download, not a streaming update that would lockup. Things seem back to normal. Automatic updater works. Thanks for the...

I managed to get MaxBlast to copy the old install to the new drive, and then ran a registry fixer (CCleaner). That allowed me to run the XP install past the stop error. Now I'm back to SP1a and am having the same problem with the Windows updater - it freezes IE, or stops while downloading the...

That's interesting. I didn't know this utility even existed. It ran (with an MSDN XP SP1a disk in the CD) without reporting any problem. I am still not able to install ASP.NET 2.0 (my test case) At least it doesn't lock up, but reports a problem when looking for downloaded components. Its...

I'm trying to reinstall the basic XP files to a SATA drive, but get this error: 0x0000000 (0x80000003,0x809F1575,0xF79C5840,0xF79C5540). I have done this several times witout problem. I have gotten the teh same message while trying to install a new SATA drive. The only reference I find to the...

duh I needed to increment the Referdt, otherwise it was an endless loop While Next3603Dt < Last3603Dt Do ( LastReferDt := Date(DateAdd("M", 6, LastReferDt)); Next3603Dt := LastREferDt; ) // add this, or evals to t/f Next3603Dt; Bob Hagan

Ok, I'll explore that. This problem was the result, I think, of an Internet virus. I've had trouble getting XP to be stable, even after a reformat, so I'm also considering putting in a new drive, and starting over from scratch. It may take me less time to rewrite the stored procedures, than...

The registry entries are: ORACLE_HOME = C:\Oracle\ora92 ORACLE_SID = BLAH Both of these appear to be correct. I'm still getting "Oracle Intelligent Agent has encountered a problem. Do you want to send MS a report?" when I reboot. The service is not running. Could that have anything to...

STARTUP NOMOUNT CREATE CONTROLFILE REUSE DATABASE "PSAAFPR" RESETLOGS NOARCHIVELOG -- SET STANDBY TO MAXIMIZE PERFORMANCE MAXLOGFILES 50 MAXLOGMEMBERS 5 MAXDATAFILES 100 MAXINSTANCES 1 MAXLOGHISTORY 226 LOGFILE GROUP 1 'C:\ORACLE\ORADATA\BLAH\REDO01.LOG' SIZE 100M...

Item 9 on: CREATE CONTROL FILE ... I get ORA-01503 CREATE CONTOLFILE failed ORA-01565 error in identifying file '%ORACLE_HOME%\DATABASE\DBS1%ORACLE_SID%.ORA' there is nothing in the Oracle\Ora92\Database\ starting DB1. There is a PWD....ORA, SPFILE....ORA, sqlnet.log, OraDim.Log, and...

Database log mode No Archive Mode Automatic archival Disabled Archive destination C:\oracle\ora92\RDBMS Oldest online log sequence 61 Current log sequence 63 Bob Hagan

I can connect and startup. However alter database archivelog; gives - ORA-00265: instance recovery required, cannot set archivelog mode Progress. Bob Hagan

I may not be understanting you. If I attempted to log on in SQLPLUS as sys, system or bob, I got "initialization in progress." With /nolog, at connect / as sysdba I got "insufficient privileges" I tried shutdown abort anyway and that may have worked - I can also do abort inside enterprise...