Re: database permissions issue


"Dave Cullen" <nospam@xxxxxxxx> wrote in message
news:43289327.4909E73C@xxxxxxxxxxx
>I have a VB6 application that works fine when I'm logged onto the PC
> (and our network) as a power user, but won't run when the normal user
> logs on. I've traced the problem to this line in the form load
> procedure:
>
> Set OraSession = CreateObject("OracleInProcServer.XOraSession")
>
> The program is supposed to attach to our Oracle server. The error
> message is Run-time error '70', permission denied.
>
> I've seen this sort of thing with .NET when running database programs
> from a shared network drive, but not with VS 6 programs and not when the
> exe is on the local drive.
>
> OS is WinXP. Can anyone offer a solution, please?


Have you contacted Oracle (searched their FAQs, KB, etc.)? That'd be the
first thing I'd do. It's quite possible that whatever component you're
creating requires certain permissions that "normal" users don't have by
default. It depends on the component/object.

--
Mike
Microsoft MVP Visual Basic




.

Relevant Pages

  • database permissions issue
    ... as a power user, but won't run when the normal user ... message is Run-time error '70', ... from a shared network drive, but not with VS 6 programs and not when the ...
    (microsoft.public.vb.general.discussion)
  • Re: RH9: I need to start ADSL-START as root for the first time after boot ....
    ... > After connecting as root, I also may disconnect and run the program as ... > normal user and it successfully connect so far. ... relevant permissions after you first start it up as root. ... BTW, while creating my home network, I used the RH network GUI to set up ...
    (comp.os.linux.networking)
  • Re: SUN Solaris User
    ... probably just create him a normal user account, ... normal rights of a normal User along with Network Management Rights. ... > Subject: SUN Solaris User ...
    (Focus-SUN)
  • Re: RH9: I need to start ADSL-START as root for the first time after boot ....
    ... >> program as normal user and it successfully connect so far. ... > relevant permissions after you first start it up as root. ... > BTW, while creating my home network, I used the RH network GUI to set up ... redhat-config-network in RH9 malfunctions (python scripts ...
    (comp.os.linux.networking)
  • "Run-time error 430" when open on one computer, fine on other
    ... We have an access database file used in a small business with two computers ... connected via a network. ... "Run-time error 430. ...
    (microsoft.public.access.modulesdaovba)