Search results for query: *

Hi All, I'm running an Intel box with Solaris 8 and Apache. I have little knowledge of UNIX web hosting and inherited the box from former coworkers. The box hosts two websites which are currently down. The power recently went out and for some reason the httpd service will no longer start as...

How would I count the number of line breaks/returns in the text of a memo field?

Error - 403 Failed to connect to server mysite.site.com(80) Reason: Remote host is not listening. Help?

Is there a query tool similar to the query grid in MS Access that speaks and displays Oracle SQL? Thanks!

Found this trigger some place for upper casing a field but am getting this error on OEM: PLS-00049: bad bind variable 'NEW.TEXT_COLUMN' CREATE OR REPLACE TRIGGER UpCase BEFORE INSERT OR UPDATE ON TableName REFERENCING OLD AS OLD NEW AS NEW FOR EACH ROW DECLARE BEGIN :new.text_column :=...

ORA-00942: table or view does not exist You don not have enough privledges to perform this operation. You must have the appropriate system and object privledges to create, edit, or drop database objects or objects outside of your schema. Why? If I connect 'Normal' then I can create the trigger.

I've been in the progress of migrating my Access backend databases to Oracle 9i through ODBC. I'm now starting to regret it and could use some good advice for resolving poor performance problems. Essentially tables containing a large number of records, say 1-2 million recs perform so poorly that...

Windows 2000 Server refuses all logon attempts with proper credentials. Prior to this the only change made was the speed of the NIC. Have tried Recovery Manager, Safe Mode boot and even removal of the NIC. The server is a Compaq ML350 and Recovery Manager cannot see the disk array so is of no...

How would I create a trigger to summarize the records in one table to a second? For example, let's say I have an empty table (TABLE1) and I insert 10 records for 3 different people for different dollar amounts. I would like the trigger to append the totals for the 3 people in TABLE2. Then...

Has anyone out there programmed a way to FTP files from Microsoft Access? Here's the core of what I would like to be able to do: For y = 1 To z For x = a To b strDay = Format(x, "00") strDatabase = Forms![frmStatusByDatabase02]![Database]...

I'm trying to permanently change the NLS/Globalization Parameters for a new/empty database using Enterprise Manager (tried ALTER DATABASE command too): NLS_DATE_FORMAT = 'MM/DD/YY' NLS_TIME_FORMAT = 'HH12:MI:SS' NLS_TIMESTAMP_FORMAT = 'MM/DD/YY HH12:MI:SS' I DO NOT want to change for just...

Problem: Receiving "ORA-12514 :TNS:listener could not resolve SERVICE_NAME given in connect descriptor" when attempting to use Enterprise Manager console to startup/shutdown a remote database. Version: Oracle 9i (9.2.0) Recommendations: Don't use Net Configuration Assistant to...

It there a way to print out or export the contents of a Crystal Reports 6 data dictionary? Thanks,

It there a way to print out or export the contents of a Crystal Reports 6 data dictionary? Thanks,

I'm running Windows 2000 Server on a Compaq ML350 with 6-36.4 GB disks. I selected Raid 0+1 during setup with SmartStart (yeah, right) but Server sees one giant logical disk and will not allow me to create seperate volumes or use stripping and mirroring in Computer Management. Only the option to...