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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

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

Jeff:

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.

I also converted the test page to a vbs script file and it runs fine when
executed. It will connect to the database and return data.

I have unitstalled both IIS and the Oracle Client. I reinstalled IIS then
restarted the server and then installed the Oracle Client and then restarted
the server again.

A step further. I acquired another test server and installed Windows 2003
Standard with all the updates on it. I then installed IIS and the Oracle
Client restarting the server and then performed same test on this server,
same problem as previously recored.

I even used a different Windows Server CD when I setup this new test server.

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

  • Re: VPN disconnection
    ... The connection still hangs/disconnects, ... subject with subject: VPN disconnection. ... Microsoft CSS Online Newsgroup Support ... if you installed SP2 on the SBS server without ...
    (microsoft.public.windows.server.sbs)
  • RE: SMTP sending failure, connection is dropped by remote host
    ... dropped the connection error. ... The routing group errors relate to the default routing group which exchange ... I have now doen a rebuild of the server applying NO service packs this time, ... > Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • Re: CEICW & software updates...
    ... SBS/Windows Server 2003, etc is just not quite UPNP aware the way it ... MVPs do not work for Microsoft ... I'm not getting prompted for an internet connection type. ... DNS server is installed and not disabled Call to Changing ...
    (microsoft.public.windows.server.sbs)
  • RE: Remote users not part of the domain
    ... The Change Server IP Address Wizard locates at Server Management\Standard ... Microsoft CSS Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... Ethernet adapter Wireless Network Connection: ...
    (microsoft.public.windows.server.sbs)
  • Re: Remote Access Routing Questions
    ... Based on my search, the VPN connection ... The difference of both methods is that the client VPN setup ... 825763 How to configure Internet access in Windows Small Business Server ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)