Re: Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 S
From: Jeff Cochran (jeff.nospam_at_zina.com)
Date: 08/17/04
- Next message: Malic: "Re: How do I publish on a site with Host headers enabled?"
- Previous message: Kristofer Gafvert: "Re: CSS and GIF referenced in .aspx page are not loading."
- In reply to: Thomas: "Re: Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 S"
- Next in thread: Jeff Cochran: "Re: Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 Serve"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 17 Aug 2004 18:12:52 GMT
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:
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
>> >>
>> >>
>> >>.
>> >>
>>
>>
>>
- Next message: Malic: "Re: How do I publish on a site with Host headers enabled?"
- Previous message: Kristofer Gafvert: "Re: CSS and GIF referenced in .aspx page are not loading."
- In reply to: Thomas: "Re: Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 S"
- Next in thread: Jeff Cochran: "Re: Oracle Database Access via IIS 6.0 ASP Pages on Windows 2003 Serve"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
