Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 Serve

Community Members:

Has anyone found an answer to the problem of accessing Oracle database from
ASP pages on IIS 6.0 on Windows 2003. I serveral ASP web applications that I
want to migrate to my new server running IIS 6.0 on Windows 2003. My Oracle
ASP applications will no longer work. I have tried Oracle 8.1.7, 9.2, and
10g client connectivity but nothing works from ASP applications. I have
eliminated the Windows Server and the Oracle drivers as a problem. The
problem seems to be directly related to IIS 6.0.

If there is no valid answer I am left with no choice but to revert back to
Windows 2000. My applications worked on Windows 2000 Server and I do not
understand nor have I been able to find an answer to the problem in my many
hours of research.

Any Microsoft professionals monitoring this site, I would appreciate your
professional response to this porblem. I am devoted to Microsoft
technologies and in my world I would prefer everything be Microsoft. But in
the real world it does not work that way and I must work with all
technologies and make all technologies work together Microsoft and Oracle
alike. I support literally hundreds of servers running Windows and want a
valid answer to this problem. If this is a Microsoft problem I want to know
how to fix it. My window for maintaining my Windows 2003 installation is
fast runing out.

I appreciate any valid comments and help.

Thank you,

Thomas

Ken
Mon Aug 16 19:59:09 CDT 2004

What exactly is the problem you are running into?

I personally know of several companies using ASP on IIS 6.0 connecting to
Oracle databases of various vintages, so it's certainly possible.

Cheers
Ken

"Thomas" <Thomas@discussions.microsoft.com> wrote in message
news:051C29AA-0066-485C-8EE0-D01750B08DEA@microsoft.com...
> Community Members:
>
> Has anyone found an answer to the problem of accessing Oracle database
> from
> ASP pages on IIS 6.0 on Windows 2003. I serveral ASP web applications
> that I
> want to migrate to my new server running IIS 6.0 on Windows 2003. My
> Oracle
> ASP applications will no longer work. I have tried Oracle 8.1.7, 9.2, and
> 10g client connectivity but nothing works from ASP applications. I have
> eliminated the Windows Server and the Oracle drivers as a problem. The
> problem seems to be directly related to IIS 6.0.
>
> If there is no valid answer I am left with no choice but to revert back to
> Windows 2000. My applications worked on Windows 2000 Server and I do not
> understand nor have I been able to find an answer to the problem in my
> many
> hours of research.
>
> Any Microsoft professionals monitoring this site, I would appreciate your
> professional response to this porblem. I am devoted to Microsoft
> technologies and in my world I would prefer everything be Microsoft. But
> in
> the real world it does not work that way and I must work with all
> technologies and make all technologies work together Microsoft and Oracle
> alike. I support literally hundreds of servers running Windows and want a
> valid answer to this problem. If this is a Microsoft problem I want to
> know
> how to fix it. My window for maintaining my Windows 2003 installation is
> fast runing out.
>
> I appreciate any valid comments and help.
>
> Thank you,
>
> Thomas

Thomas
Mon Aug 16 20:24:26 CDT 2004

Ken:

I am having trouble getting my database connections to
work. I am using the Microsoft's ODBC Driver for Oracle
and it is as if the server identified in the connect
string cannot be found in the tnsname.ora file.

I have tried all avaiable drivers that will allow for a
connection to an Oracle database. This same code works
fine on a Windows 2000 server running IIS 5.0 using the
Oracle client's I have indicated.

The Oracle client, currently 10g, is installed and
functioning correctly. I can perform a tnsping with
expected return results. I can access the Oracle
databases with SQL*PLUS. I test my ASP code in a
test.vbs script file on the local file system and can
connect successfully and retrive expected results from
the database using a simple SQL query.

I my research of this problem I have found that many
others have experienced the same or similar problems. Of
all of these that I have found not one provides a
solution.

How do you have your clients connecting the Oracle
databases? Did you use a tool to create your database
connection? Did you script your connection string by
hand?

Your help and comments are welcome.

Thank you,

Thomas
>-----Original Message-----
>What exactly is the problem you are running into?
>
>I personally know of several companies using ASP on IIS
6.0 connecting to
>Oracle databases of various vintages, so it's certainly
possible.
>
>Cheers
>Ken
>
>"Thomas" <Thomas@discussions.microsoft.com> wrote in
message
>news:051C29AA-0066-485C-8EE0-
D01750B08DEA@microsoft.com...
>> Community Members:
>>
>> Has anyone found an answer to the problem of accessing
Oracle database
>> from
>> ASP pages on IIS 6.0 on Windows 2003. I serveral ASP
web applications
>> that I
>> want to migrate to my new server running IIS 6.0 on
Windows 2003. My
>> Oracle
>> ASP applications will no longer work. I have tried
Oracle 8.1.7, 9.2, and
>> 10g client connectivity but nothing works from ASP
applications. I have
>> eliminated the Windows Server and the Oracle drivers
as a problem. The
>> problem seems to be directly related to IIS 6.0.
>>
>> If there is no valid answer I am left with no choice
but to revert back to
>> Windows 2000. My applications worked on Windows 2000
Server and I do not
>> understand nor have I been able to find an answer to
the problem in my
>> many
>> hours of research.
>>
>> Any Microsoft professionals monitoring this site, I
would appreciate your
>> professional response to this porblem. I am devoted
to Microsoft
>> technologies and in my world I would prefer everything
be Microsoft. But
>> in
>> the real world it does not work that way and I must
work with all
>> technologies and make all technologies work together
Microsoft and Oracle
>> alike. I support literally hundreds of servers
running Windows and want a
>> valid answer to this problem. If this is a Microsoft
problem I want to
>> know
>> how to fix it. My window for maintaining my Windows
2003 installation is
>> fast runing out.
>>
>> I appreciate any valid comments and help.
>>
>> Thank you,
>>
>> Thomas
>
>
>.
>

Ken
Mon Aug 16 20:40:42 CDT 2004

Are you getting some kind of error message?

What type of connection are you using? ODBC DSN? OLEDB?

Sorry to hassle you about these things, but if I go an hassle someone else
to look over the problem, I'd need to have as much info to put in front of
them as possible.

At the moment, what you are saying is something similar to: "my car doesn't
work - I'm doing the same things as what I did in my old car, but that's not
working with my new car. I've searched and I see lots of others have similar
problems". But we don't know whether your new car actually has something
wrong with it, or just doesn't have any petrol/gas in the tank, or is a
manual and your last car was an automatic etc.

Thanks.

Cheers
Ken

"Thomas" <anonymous@discussions.microsoft.com> wrote in message
news:012301c483f8$efb52250$a301280a@phx.gbl...
> Ken:
>
> I am having trouble getting my database connections to
> work. I am using the Microsoft's ODBC Driver for Oracle
> and it is as if the server identified in the connect
> string cannot be found in the tnsname.ora file.
>
> I have tried all avaiable drivers that will allow for a
> connection to an Oracle database. This same code works
> fine on a Windows 2000 server running IIS 5.0 using the
> Oracle client's I have indicated.
>
> The Oracle client, currently 10g, is installed and
> functioning correctly. I can perform a tnsping with
> expected return results. I can access the Oracle
> databases with SQL*PLUS. I test my ASP code in a
> test.vbs script file on the local file system and can
> connect successfully and retrive expected results from
> the database using a simple SQL query.
>
> I my research of this problem I have found that many
> others have experienced the same or similar problems. Of
> all of these that I have found not one provides a
> solution.
>
> How do you have your clients connecting the Oracle
> databases? Did you use a tool to create your database
> connection? Did you script your connection string by
> hand?
>
> Your help and comments are welcome.
>
> Thank you,
>
> Thomas
>>-----Original Message-----
>>What exactly is the problem you are running into?
>>
>>I personally know of several companies using ASP on IIS
> 6.0 connecting to
>>Oracle databases of various vintages, so it's certainly
> possible.
>>
>>Cheers
>>Ken
>>
>>"Thomas" <Thomas@discussions.microsoft.com> wrote in
> message
>>news:051C29AA-0066-485C-8EE0-
> D01750B08DEA@microsoft.com...
>>> Community Members:
>>>
>>> Has anyone found an answer to the problem of accessing
> Oracle database
>>> from
>>> ASP pages on IIS 6.0 on Windows 2003. I serveral ASP
> web applications
>>> that I
>>> want to migrate to my new server running IIS 6.0 on
> Windows 2003. My
>>> Oracle
>>> ASP applications will no longer work. I have tried
> Oracle 8.1.7, 9.2, and
>>> 10g client connectivity but nothing works from ASP
> applications. I have
>>> eliminated the Windows Server and the Oracle drivers
> as a problem. The
>>> problem seems to be directly related to IIS 6.0.
>>>
>>> If there is no valid answer I am left with no choice
> but to revert back to
>>> Windows 2000. My applications worked on Windows 2000
> Server and I do not
>>> understand nor have I been able to find an answer to
> the problem in my
>>> many
>>> hours of research.
>>>
>>> Any Microsoft professionals monitoring this site, I
> would appreciate your
>>> professional response to this porblem. I am devoted
> to Microsoft
>>> technologies and in my world I would prefer everything
> be Microsoft. But
>>> in
>>> the real world it does not work that way and I must
> work with all
>>> technologies and make all technologies work together
> Microsoft and Oracle
>>> alike. I support literally hundreds of servers
> running Windows and want a
>>> valid answer to this problem. If this is a Microsoft
> problem I want to
>>> know
>>> how to fix it. My window for maintaining my Windows
> 2003 installation is
>>> fast runing out.
>>>
>>> I appreciate any valid comments and help.
>>>
>>> Thank you,
>>>
>>> Thomas
>>
>>
>>.
>>

jeff
Tue Aug 17 09:25:46 CDT 2004

On Mon, 16 Aug 2004 16:47:01 -0700, Thomas
<Thomas@discussions.microsoft.com> wrote:

>Has anyone found an answer to the problem of accessing Oracle database from
>ASP pages on IIS 6.0 on Windows 2003.

*What* problem of accessing Oracle databases from ASP in IIS6? Since
at least a few places are doing it fine, there seems to be a solution
to whatever problem you're having.

>I serveral ASP web applications that I
>want to migrate to my new server running IIS 6.0 on Windows 2003. My Oracle
>ASP applications will no longer work. I have tried Oracle 8.1.7, 9.2, and
>10g client connectivity but nothing works from ASP applications. I have
>eliminated the Windows Server and the Oracle drivers as a problem. The
>problem seems to be directly related to IIS 6.0.

I'll ask again -- *What* problem?

>If there is no valid answer I am left with no choice but to revert back to
>Windows 2000. My applications worked on Windows 2000 Server and I do not
>understand nor have I been able to find an answer to the problem in my many
>hours of research.

Third time's a charm? *What* problem?

>Any Microsoft professionals monitoring this site, I would appreciate your
>professional response to this porblem. I am devoted to Microsoft
>technologies and in my world I would prefer everything be Microsoft. But in
>the real world it does not work that way and I must work with all
>technologies and make all technologies work together Microsoft and Oracle
>alike. I support literally hundreds of servers running Windows and want a
>valid answer to this problem. If this is a Microsoft problem I want to know
>how to fix it. My window for maintaining my Windows 2003 installation is
>fast runing out.

Best help I can offer is to suggest you post the problem you're
having. Error messages, event log entries, expected results that
don't happen, etc. Have you tried a soimple app that connects to the
database and reads records from a table? If not, do that and post any
errors.

Jeff

jeff
Tue Aug 17 09:33:07 CDT 2004

On Mon, 16 Aug 2004 18:24:26 -0700, "Thomas"
<anonymous@discussions.microsoft.com> wrote:

>I am having trouble getting my database connections to
>work. I am using the Microsoft's ODBC Driver for Oracle
>and it is as if the server identified in the connect
>string cannot be found in the tnsname.ora file.

Have you tried OLEDB? Since ODBC is deprectaed it makes sense to do
so.

>I have tried all avaiable drivers that will allow for a
>connection to an Oracle database. This same code works
>fine on a Windows 2000 server running IIS 5.0 using the
>Oracle client's I have indicated.

That doesn't mean much.

>The Oracle client, currently 10g, is installed and
>functioning correctly. I can perform a tnsping with
>expected return results. I can access the Oracle
>databases with SQL*PLUS. I test my ASP code in a
>test.vbs script file on the local file system and can
>connect successfully and retrive expected results from
>the database using a simple SQL query.

Are you signed in as the same user that the ASP app is running under?

>I my research of this problem I have found that many
>others have experienced the same or similar problems. Of
>all of these that I have found not one provides a
>solution.

You still haven't posted a probelm.

>How do you have your clients connecting the Oracle
>databases?

OLEDB.

>Did you use a tool to create your database
>connection?

Notepad works fine.

>Did you script your connection string by
>hand?

The real question is: Have you? And what might that string be? And
what error might it produce?

>Your help and comments are welcome.

But yours are *needed*. Tell us:

Exactly what connection you're using
Exactly what error you're receiving
Exactly what even log entry you find
Exactly what is or isn't happening that you expect or expect not to
happen.

Give us something to go on. So far we know it worked as written on
IIS5/W2K and it doesn't work as written on IIS6/Server 2003. From
those details it could simply be that when you try to use it on IIS6
your roommate smacks you with a brick and knocks you unconscious.

Jeff

jeff
Tue Aug 17 13:12:52 CDT 2004

Answers inline:


On Tue, 17 Aug 2004 10:09:04 -0700, Thomas
<Thomas@discussions.microsoft.com> wrote:

>Ken,
>
>I have a 1937 Packard when I am going down the road it goes klunk, klunk,
>kaput and then just stops...
>
>Seriously, here are the details of which I will attempt to provide all.
>
>Windows 2003 Standard installed with all of the latest Windows updates
>applied. No virus software installed yet.
>
>IIS Features installed.
>
> Common Files
> File Transport Protocol
> FrontPage 2002 Server Extensions
> Internet Information Services Manager
> Internet Printing
>
> World Wide Service
>
> Active Server Pages
> Internet Data Connector
> Remote Administration (HTML)
> Remotes Desktop Web Connection
> Server Side Includes
> WebDav Publishing
> World Wide Web Service
>
>Web Service Extensions
>
> All available services are allowed
>
>Microsoft SQL Server 2000 Standard with SP3a installed on same box.
>
>Oracle 10g Client is installed on the Windows Server.
>
>I have tried ODBC, DSN, DSN Less, OLE DB, and OLE DB for Oracle none of
>which have worked. The origianl data connect string from the ASP page that
>works on Windows 2000 with IIS 5.0.
>
>This is my standard DSN Less connection.
>
>function GetMI9OraSrvDataConnection()
> DIM oConn, strConn
> Set oConn = Server.CreateObject("ADODB.Connection")
> strConn = "Provider=MSDASQL.1; " & _
> "Driver={Microsoft ODBC for Oracle}; " & _
> "SERVER=MI9_XYZDB; UID=Author; PWD=Dole#;"
> oConn.Open strConn
> set GetMI9OraSrvDataConnection = oConn
>end function
>
>Set dbMI9xOraConn = GetMI9OraSrvDataConnection
>
>Error Message Returned from Web Browser
>
>Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Start here:

Why do I get database-related 80004005 errors?
http://www.aspfaq.com/show.asp?id=2009

>[Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on SQL_HANDLE_ENV
>failed
>
>The browser reports it as a HTTP 500 Internal server errror
>
>I have tried several connect strings that I developed using a UDL connection
>to build. They all test successfully from the UDL tool.
>
>Microsoft OLE DB Provider for ODBC Drivers
>
>Provider=MSDASQL.1;Password=Dole;Persist Security Info=True;User
>ID=Author;Data Source=MI9XYDB
>
>Microsoft OLE DB Provider for Oracle
>
>Provider=MSDAORA.1;Password=Dole;User ID=Author;Data Source=MI9XYZDB;Persist
>Security Info=True
>
>Oracle Provider for OLE DB
>
>Provider=OraOLEDB.Oracle.1;Password=Dole;Persist Security Info=True;User
>ID=Author;Data Source=MI9XYZDB
>
>When this page is executed from MSIE web browser I recieve the error noted
>above. The only exception is when I use the Oracle provider the browser
>complains that the provider is not installed. I know for a fact that it is
>and that I can connect using the provider from a UDL file. One other time I
>did receive and error that the connect identifier user could not be
>determined.
>
>Ken, can you share with me how you have your Oracle clients setup through
>IIS 6.0 on Windows 2003?

Start with:

http://www.able-consulting.com/MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForOracleFromMicrosoft

Make sure you have the latest MDAC (2.8) installed, plus the client I
know has it working is using Oracle 8.x.

Might also look at:

http://support.microsoft.com/default.aspx?scid=kb;en-us;264012&Product=mdac
http://support.microsoft.com/default.aspx?scid=kb;en-us;259959&Product=mdac
http://support.microsoft.com/default.aspx?scid=kb;en-us;255084&Product=mdac

Jeff

>
>If you need more details I will do my best provided them.
>
>Thank you,
>
>Thomas
>
>"Ken Schaefer" wrote:
>
>> Are you getting some kind of error message?
>>
>> What type of connection are you using? ODBC DSN? OLEDB?
>>
>> Sorry to hassle you about these things, but if I go an hassle someone else
>> to look over the problem, I'd need to have as much info to put in front of
>> them as possible.
>>
>> At the moment, what you are saying is something similar to: "my car doesn't
>> work - I'm doing the same things as what I did in my old car, but that's not
>> working with my new car. I've searched and I see lots of others have similar
>> problems". But we don't know whether your new car actually has something
>> wrong with it, or just doesn't have any petrol/gas in the tank, or is a
>> manual and your last car was an automatic etc.
>>
>> Thanks.
>>
>> Cheers
>> Ken
>>
>> "Thomas" <anonymous@discussions.microsoft.com> wrote in message
>> news:012301c483f8$efb52250$a301280a@phx.gbl...
>> > Ken:
>> >
>> > I am having trouble getting my database connections to
>> > work. I am using the Microsoft's ODBC Driver for Oracle
>> > and it is as if the server identified in the connect
>> > string cannot be found in the tnsname.ora file.
>> >
>> > I have tried all avaiable drivers that will allow for a
>> > connection to an Oracle database. This same code works
>> > fine on a Windows 2000 server running IIS 5.0 using the
>> > Oracle client's I have indicated.
>> >
>> > The Oracle client, currently 10g, is installed and
>> > functioning correctly. I can perform a tnsping with
>> > expected return results. I can access the Oracle
>> > databases with SQL*PLUS. I test my ASP code in a
>> > test.vbs script file on the local file system and can
>> > connect successfully and retrive expected results from
>> > the database using a simple SQL query.
>> >
>> > I my research of this problem I have found that many
>> > others have experienced the same or similar problems. Of
>> > all of these that I have found not one provides a
>> > solution.
>> >
>> > How do you have your clients connecting the Oracle
>> > databases? Did you use a tool to create your database
>> > connection? Did you script your connection string by
>> > hand?
>> >
>> > Your help and comments are welcome.
>> >
>> > Thank you,
>> >
>> > Thomas
>> >>-----Original Message-----
>> >>What exactly is the problem you are running into?
>> >>
>> >>I personally know of several companies using ASP on IIS
>> > 6.0 connecting to
>> >>Oracle databases of various vintages, so it's certainly
>> > possible.
>> >>
>> >>Cheers
>> >>Ken
>> >>
>> >>"Thomas" <Thomas@discussions.microsoft.com> wrote in
>> > message
>> >>news:051C29AA-0066-485C-8EE0-
>> > D01750B08DEA@microsoft.com...
>> >>> Community Members:
>> >>>
>> >>> Has anyone found an answer to the problem of accessing
>> > Oracle database
>> >>> from
>> >>> ASP pages on IIS 6.0 on Windows 2003. I serveral ASP
>> > web applications
>> >>> that I
>> >>> want to migrate to my new server running IIS 6.0 on
>> > Windows 2003. My
>> >>> Oracle
>> >>> ASP applications will no longer work. I have tried
>> > Oracle 8.1.7, 9.2, and
>> >>> 10g client connectivity but nothing works from ASP
>> > applications. I have
>> >>> eliminated the Windows Server and the Oracle drivers
>> > as a problem. The
>> >>> problem seems to be directly related to IIS 6.0.
>> >>>
>> >>> If there is no valid answer I am left with no choice
>> > but to revert back to
>> >>> Windows 2000. My applications worked on Windows 2000
>> > Server and I do not
>> >>> understand nor have I been able to find an answer to
>> > the problem in my
>> >>> many
>> >>> hours of research.
>> >>>
>> >>> Any Microsoft professionals monitoring this site, I
>> > would appreciate your
>> >>> professional response to this porblem. I am devoted
>> > to Microsoft
>> >>> technologies and in my world I would prefer everything
>> > be Microsoft. But
>> >>> in
>> >>> the real world it does not work that way and I must
>> > work with all
>> >>> technologies and make all technologies work together
>> > Microsoft and Oracle
>> >>> alike. I support literally hundreds of servers
>> > running Windows and want a
>> >>> valid answer to this problem. If this is a Microsoft
>> > problem I want to
>> >>> know
>> >>> how to fix it. My window for maintaining my Windows
>> > 2003 installation is
>> >>> fast runing out.
>> >>>
>> >>> I appreciate any valid comments and help.
>> >>>
>> >>> Thank you,
>> >>>
>> >>> Thomas
>> >>
>> >>
>> >>.
>> >>
>>
>>
>>

jeff
Tue Aug 17 15:30:55 CDT 2004

On Tue, 17 Aug 2004 10:45:03 -0700, Thomas
<Thomas@discussions.microsoft.com> wrote:


>I also want to mention that I have tried creating just the data connection
>portion of my page as a quick test. The test.asp page I setup with just the
>database connection errors out the same as before the database connection
>function is called.

The 8004005 error you posted is basically a permissions error. My
guess is it works from a command line because you're logged in as a
user who has access, from your app the user has no access. Remember
you may be using the anonymous user account in your ASP script and not
the account you log into the system as.

Jeff

Thomas
Tue Aug 17 21:43:02 CDT 2004

Jeff:

What would you suggest for permission settings?

For what user on what directories?

I gave the anonymous user account list/execute/read permissions on the
Oracle directory but the page still does display as before.

If you know how to do this I would appreciate your guidance and help.

Thank you,

Thomas

"Jeff Cochran" wrote:

> On Tue, 17 Aug 2004 10:45:03 -0700, Thomas
> <Thomas@discussions.microsoft.com> wrote:
>
>
> >I also want to mention that I have tried creating just the data connection
> >portion of my page as a quick test. The test.asp page I setup with just the
> >database connection errors out the same as before the database connection
> >function is called.
>
> The 8004005 error you posted is basically a permissions error. My
> guess is it works from a command line because you're logged in as a
> user who has access, from your app the user has no access. Remember
> you may be using the anonymous user account in your ASP script and not
> the account you log into the system as.
>
> Jeff
>

Paul
Wed Aug 18 05:37:56 CDT 2004

On Mon, 16 Aug 2004 16:47:01 -0700, Thomas
<Thomas@discussions.microsoft.com> wrote:

>Community Members:
>
>Has anyone found an answer to the problem of accessing Oracle database from
>ASP pages on IIS 6.0 on Windows 2003. I serveral ASP web applications that I
>want to migrate to my new server running IIS 6.0 on Windows 2003. My Oracle
>ASP applications will no longer work. I have tried Oracle 8.1.7, 9.2, and
>10g client connectivity but nothing works from ASP applications. I have
>eliminated the Windows Server and the Oracle drivers as a problem. The
>problem seems to be directly related to IIS 6.0.
>
>If there is no valid answer I am left with no choice but to revert back to
>Windows 2000. My applications worked on Windows 2000 Server and I do not
>understand nor have I been able to find an answer to the problem in my many
>hours of research.
>
>Any Microsoft professionals monitoring this site, I would appreciate your
>professional response to this porblem. I am devoted to Microsoft
>technologies and in my world I would prefer everything be Microsoft. But in
>the real world it does not work that way and I must work with all
>technologies and make all technologies work together Microsoft and Oracle
>alike. I support literally hundreds of servers running Windows and want a
>valid answer to this problem. If this is a Microsoft problem I want to know
>how to fix it. My window for maintaining my Windows 2003 installation is
>fast runing out.
>
>I appreciate any valid comments and help.
>
>Thank you,
>
>Thomas

Thomas,

I'm not really sure what you mean by "applications will no longer
work" or even "nothing works from ASP applications" - hint: you need
to post real live meaningful error messages in order to receive
meaningful help here

However, that said there can be a number of causes of connectivity
failure from IIS to Oracle but the most common by far is permissions.

Have a look at this KB article for some troubleshooting tips :

How To Troubleshoot an ASP-to-Oracle Connectivity Problem
http://support.microsoft.com/?id=255084


Regards,

Paul Lynch
MCSE

jeff
Wed Aug 18 06:06:57 CDT 2004

On Tue, 17 Aug 2004 19:43:02 -0700, Thomas
<Thomas@discussions.microsoft.com> wrote:

>What would you suggest for permission settings?

The user the ASP is running under needs permissions to the database
and connection. TRy using a product like Filemon to see what's
required, and look at your log files to see what's being requested and
denied.

>For what user on what directories?

An Oracle group may be able to tell you that, or monitoring the files
requested may help.

>I gave the anonymous user account list/execute/read permissions on the
>Oracle directory but the page still does display as before.
>
>If you know how to do this I would appreciate your guidance and help.

I know what the error indicates, but I don't use Oracle so I can't
provide specifics there, sorry.

Jeff


>Thomas
>
>"Jeff Cochran" wrote:
>
>> On Tue, 17 Aug 2004 10:45:03 -0700, Thomas
>> <Thomas@discussions.microsoft.com> wrote:
>>
>>
>> >I also want to mention that I have tried creating just the data connection
>> >portion of my page as a quick test. The test.asp page I setup with just the
>> >database connection errors out the same as before the database connection
>> >function is called.
>>
>> The 8004005 error you posted is basically a permissions error. My
>> guess is it works from a command line because you're logged in as a
>> user who has access, from your app the user has no access. Remember
>> you may be using the anonymous user account in your ASP script and not
>> the account you log into the system as.
>>
>> Jeff
>>