MQ exit fails to load the Oracle driver

[FOR]

I am new to using the MQseries.
We set up the MQ server (v.5.3) on a Win 2k machine.
We have a queue manager, queue, and a channel, and a client application sending messages to that queue.
Now we are trying to use an exit to authenticate the users that send messages.
The exit receives the messages, and then should extract the user information, and connect to a database to validate the users' identities.
To do this, we have an Oracle 9i (Rel. 2) installed. We set up a System DSN on the MQ server to connect to the db and retrieve info as needed.
When we run the system, however, the SQLConnect command fails. My log files list the following error message:

=========================
szSqlState = IM003
pfNativeError = 160

szErrorMsg = Specified driver could not be loaded due to system error 5 (Oracle in OraHome92).

pcbErrorMsg = 164
=========================

As a side kick, if I log on to the server, and run the same code, it all works fine.
Looking on the net, it seems that this error appears when the user that is attempting to use the ODBC driver does not have permissions to the Oracle directory. However, we tried to give that permission to the user that the MQ service is logged on as (Actually, I switched the MQ service to log on as Administrator and gave the Administrator rights to the Oracle directory). It still didn't help.

Any suggerstions/thoughts/hints ?

Thanks for the attention,
Frank "Olorin" Rizzi

 

[FOR]

I think I have an answer.
Or, at least, I got it to work...
..for anyone else who might be having the same problem, here goes.

You need to give permissions to the Oracle directory to the user. I had to try different things in order to make it work, but I believe that the directory in question is <Oracle installation>/Ora92/bin

Hope this helps,
F.O.R.