Re: Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 S

From: Thomas (Thomas_at_discussions.microsoft.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 10:15:03 -0700

Jeff:

Here are the details that I posted back to Ken. Speciffically, the problem
is with database connectivity. Yes I have tried every available driver
resource available for Oracle. It does not seem that I am able to
communicate back through IIS to SQL*NET installed for the Oracle Client.

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'

[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.

If you need more details I will do my best provided them.

Thank you,

Thomas

"Jeff Cochran" wrote:

> 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
>

Relevant Pages
Loading