Search results for query: *

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

1) I can sqlplus nolog, However connect/ as sysdba gives ORA-01031: insufficient privileges User "bob" is in the ORA_DBA group, but logging in as bob gives "Initialization or shutdown in progress" 3/4) I don't care about example.dbf at all. I thought that since that got trashed, and the...

Hi Thanks for the advice. Unfortunately, I was not able to start SQLPLUS. I logged as sys; it thought the password was invalid. Using orapwd to reset made no difference. I had also had messages saying that Intelligent Agent had encountered an error and would terminate, so I finally decided...

I recently had a machine crash and wipe out my Oracle install. I have copies of the admin and oradata directories and was able to restore them. The example.dbf must be damaged. Startup goes as far as mounting, then errors when it tries to open. ORA-01122 database file 5 failed verification...

WhilePrintingRecords; DateVar LastReferDt; DateVar Last3603Dt; DateVar Next3603Dt; // hardcoded for test Last3603Dt := DATE(2005,4,1); LastReferDt := DATE(2001,1,1); Next3603Dt := DATE(1999,1,1); IF Last3603Dt > DATE(0,0,0) THEN While Next3603Dt < Last3603Dt Do (...

Interesting. That works Thanks Bob Hagan