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

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

Date: Mon, 16 Aug 2004 18:24:26 -0700

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

Relevant Pages

  • Re: ADO Connection Timeout
    ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
  • Complicated Connection Problems bewteen ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.access.adp.sqlserver)
  • Complicated Connection Problem between ADP and SQL Server
    ... This database ... expertise for getting the user workstations talking to the SQL Server. ... connection would fail and the adp wouldn't be able to talk to the server. ... might be in my ADO connection string. ...
    (microsoft.public.sqlserver.connect)
  • Re: ADO Connection Timeout
    ... so what happens when a connection failure forces one station to revert ... to a local database? ... Further, you *will* have contention issues, Jet does not support record ... to the central server, but you are willing to live with periods where it ...
    (microsoft.public.data.ado)
  • Re: ADO Connection Timeout
    ... When the first test is run, the results are stored in the central database. ... to the central server, but you are willing to live with periods where it ... i.e. a local database or even a text file. ... to function until the connection can be restored to the server. ...
    (microsoft.public.data.ado)
Loading