Earlier today, I blogged about the connection problem between IIS and Oracle. I finally found the answer. The problem is actually very simple, it is related to NTFS File permission.

All this time I thought that when you give a user permission to a parent folder, the permission will automatically inherited by the child folders and files (if you click the Advanced button in Folder’s Properties – Security tab, the “Inherit from parent the permission entries that apply to child objects. ….” is checked by default).

So I did add full-control permission to the Oracle Home folder for the IIS Anonymous User account as recommended by Microsoft Knowledge Base. But it didn’t help.

After trying to use the Oracle OLE DB Provider (provided by Oracle, previously using the one provided by Microsoft), I encountered a new error message. I googled for it, and I found that I must REPLACE the child objects’ NTFS security permission in the Oracle Home Folder to make the parent’s folder NTFS security permission transcended to the child objects.

So remember, after added the IIS Anonymous User (IUSR_…) to Oracle Home’s folder, we need to force the permission to apply to its child folders and files. Hopefully the following screenshots will help.

I have deployed my CPAMS application to the production server. To my dismay, I encountered this error message:

“Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.

Provider is unable to function until these components are installed.

So far I have used these resources to resolve this problem:

1. How To Troubleshoot an ASP-to-Oracle Connectivity Problem
2. OTN Discussion Forums : Oracle client and networking components
3. System.Data.OracleClient requires Oracle client software version 8.1.7 or greater

None of them able to resolve the issue. I’ll update more on this issue later on.

source

This week I will be stationed at Penjuru warehouse office, somewhere near Jurong East. I will be assisting the delivery arrangement for goods to the customer. My main job would basically calling customer, confirming the delivery date and time. I think it will be fun 🙂

The last time I was doing something like this was many years back, during my university days. It was during the school break, a friend offered us to go for part time job in a call center. Our job is to call a list of numbers, and asked them for survey. It was a sure though job. I don’t think people will waste their time answering questionnaire without anything in return 🙂

This time, it is much easier. Listening that your goods will arrive soon is much more better than answering questionnaire 🙂

Few things that I learned from making a number of phone calls this morning:

1. Always greet the customer with his/her surname. It is a courtesy to do so
2. Smile while you are talking. Somehow people actually can ‘hear’ your smile
3. Confirm the details of the goods to be delivered, and the shipping address
4. Be careful when customer requested for change of address, or change of recipient. To prevent fraudulent recipient, a further confirmation with the actual buyer is a must.
5. Repeat all things that has been confirmed.
6. Say ‘Thank you and have a nice day’ before putting down the phone

What do you think?