Thank you for your response. Yes, I did install Oracle 11g 32 bit client from our company's site but it didn't work well before at one point, so that could be the problem too. I don't see it on Oracle site anymore though. Any idea where I can download Oracle 32 bit client from?
Anything else that you can think of like dsn, environment variables etc?