Question Only the network admin can get the MS Access 2007 database to connect to the Oracle?

[binoj]

We were attempting to connect Oracle database from Access 2007. We installed MDAC 2.8 and created the DSNs and everything seems to be working fine when the network admin is logged in. Once he logs off and the normal user logs in the ODBC connection doesn't seem to work.
I get the following error message

[Microsoft][ODBC Driver for oracle][Oracle] (#0) [Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed IM006 0 [Microsoft][ODBC Driver Manager] Driver’s SQLSetConnectAttr failed(#0)

What should I do to fix this? Please Advise.

 

[jdraw]

see if this helps
http://support.microsoft.com/kb/822841

 

[binoj]

The problem in the kb article doesn't seem to the issue in my case. As I can connect when logged in as a network admin. Moreover this problem is applicable to MDAC 2.7 . I have MDAC 2.8 sp1.

 

[binoj]

It was an issue with incorrect installation. The environment path variable was not set up correctly. When we entered the Oracle client location in the environment path variable it worked correctly.

Looks like for admin user this was not necessary somehow.