ODBC permission problem

  • Thread starter Thread starter paul
  • Start date Start date
P

paul

Hi,
I have just recieved my new Dell PC With Vista Business installed.

First I have joined our company domain, and created accounts in the user
control panel that have admin rights.

I have installed the ORACLE ODBC client whilst logged in as the computer
administrator, and then set up the relevant system DSN.

Then when I log in to my MSAccess DB it works fine, but when I log out as
the administrator, and log in with my usual username (Which is also an
administrator), I cannot read link tables.


I get an error "SQL_HANDLE_ENV failed (#0)"

If I test the system DSN in the ODBC Datasource Administrator it says test
successfull.

I am thinking that maybe there is a file that I do not have privelidges to
read, maybe a temp file but I cannot figure it out.

Can anybody help ?

Thanks
 
Good news,
I found that if I turn UAC off it works (if you have the same problem, UAC
is in Control Panel/User Accounts/ and click Turn User Account Control on or
off.)

But ideally, I'd like to leave it turned on and fix the problem correctly.

Thanks

Paul
 
Back
Top