IIS App, VB, and Oracle: Permission Denied?

[VicWozniak]

Hello.

My System:
Windows 2000 Pro.
Visual Basic 6.0
Oracle9i
- The database I am accessing is installed on this machine
- Development of our software is also on this machine

The program is an IIS Application created in VB 6.0 Enterprise
Edition.
Since the main program I am working on will not connect to the DB I
have created a test program. The webclass file contains the following:

Option Explicit
Option Compare Text
Public oras as OraSessionClass
Public orad as OraDatabase

Private Sub WebClass_Start()
On Error Goto lerror

Response.Clear
Response.Write("Start<BR>")
Set oras = CreateObject("OracleInProcServer.XOraSession")
Response.Write("OpenDB<BR>")
Set orad = oras.OpenDatabase("mydb","user/pwd",CInt(0))
If orad.ConnectionOK Then
Response.Write ("Connected...<BR>")
End If
Response.Write ("END")
Response.End
Exit Sub

lerror:
Response.Write ("ERROR: " & Err.Number & "<BR>")
Response.Write ("DESCR: " & Err.Description & "<BR>")
Response.End
End Sub

Of course, under references I have checked:
Oracle InProc Server 4.0 Type Library
OraOLEDB 1.0 Type Library

which are located in C:\oracle\ora9\bin\

Running from VB is OK, so the output looks like:

Start
OpenDB
Connected...
END

Now I run the package and deployment wizzard and use Standard Setup
Package, since I am installing this on the same machine, I don't need
to deploy it anywhere. I include the ASP file which access the IIS
DLL (the code above) and do not share oip9.tlb and oraoledb.dll
(although I've tried sharing as well which makes no difference in the
error I get) and I install to the Application directory. I install
to:

C:\Inetpub\wwwroot\SUBDIR\

where the ASP file will be accessed via Internet or network.

I have a test html file which contains the following:
<form action=http://localhost/SUBDIR/TEST.ASP method=POST>
<input type="submit" value="test">
</form>

This will send a Post to the ASP file which will run the IIS DLL.
Sending this post results in the following:

Start
ERROR: 70
DESCR: Permission denied

If I run from VB, it runs fine. Also, if I run from VB and keep it
running, then use the test HTML post, the installed version also
works?!

I have tried adding users to the SUBDIR directory, giving them full
access etc.

I have been stuck on this for a while and need help.

Please feel free to email me directly at:
[email]victor.wozniak@modular.com[/email]
Thanks IA.

[VicWozniak]

Sorry, that email address should be:

[email]victor.wozniak@modulary.com[/email]

[VicWozniak]

Thanks for all you help! (being sarcastic... no one replied)

I figured it out myself.

There was a VB runtime dll which I was installing on the same machine
which has VB 6 installed on. Doing so created the problem. Not
including this dll was the trick to makes the program work on the
development computer.

Of course, to have this run on any other machine which does not have
VB 6 installed, this dll must be included.

I hope this helps someone else out there.

Wankers.

[Ray at]

I don't feel that I'm a wanker for not answering.

Ray at work

"VicWozniak" <vwozniak@telus.net> wrote in message
news:1e5d5a39.0311071349.3863014c@posting.google.c om...

> Thanks for all you help! (being sarcastic... no one replied)
>
> I figured it out myself.
>
> There was a VB runtime dll which I was installing on the same machine
> which has VB 6 installed on. Doing so created the problem. Not
> including this dll was the trick to makes the program work on the
> development computer.
>
> Of course, to have this run on any other machine which does not have
> VB 6 installed, this dll must be included.
>
> I hope this helps someone else out there.
>
> Wankers.

[VicWozniak]

You'd only be a wanker if you knew something that could help me out
but didn't bother to reply. If you had nothing to contribute, then
obviously I don't expect you to reply. But if you had some knowledge
which I possibly could have found beneficial, it would have been
appreciated, and not replying would cast you as a wanker.

:)

I'm not really serious btw... I was pretty much just venting
frustration.

Vic... also at work

"Ray at <%=sLocation%>" <myfirstname at lane34 dot com> wrote in message news:<ucmo5qXpDHA.2592@TK2MSFTNGP10.phx.gbl>...

> I don't feel that I'm a wanker for not answering.
>
> Ray at work
>
> "VicWozniak" <vwozniak@telus.net> wrote in message
> news:1e5d5a39.0311071349.3863014c@posting.google.c om...

> > Thanks for all you help! (being sarcastic... no one replied)
> >
> > I figured it out myself.
> >
> > There was a VB runtime dll which I was installing on the same machine
> > which has VB 6 installed on. Doing so created the problem. Not
> > including this dll was the trick to makes the program work on the
> > development computer.
> >
> > Of course, to have this run on any other machine which does not have
> > VB 6 installed, this dll must be included.
> >
> > I hope this helps someone else out there.
> >
> > Wankers.

[Ray at]

You wanker. :P

Ray at home

"VicWozniak" <vwozniak@telus.net> wrote in message
news:1e5d5a39.0311101545.580b01cf@posting.google.c om...

> You'd only be a wanker if you knew something that could help me out
> but didn't bother to reply. If you had nothing to contribute, then
> obviously I don't expect you to reply. But if you had some knowledge
> which I possibly could have found beneficial, it would have been
> appreciated, and not replying would cast you as a wanker.
>
> :)
>
> I'm not really serious btw... I was pretty much just venting
> frustration.
>
> Vic... also at work