Thank you everyone for the advice. The problem does turn out to be the 
Oracle client. Some of our users are using Ora95 and some are using OraNT. 
I developed it with Oracle8i. Due to the different versions the program 
would not run. I installed 8i client on another machine and it works fine.