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

From: Ken Schaefer (kenREMOVE_at_THISadOpenStatic.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 11:40:42 +1000

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

Relevant Pages

  • RE: ADO.Net Connection Pooling Problem with Oracle
    ... the CLR is releasing the connection to your database. ... the number of database sessions in Oracle seem to ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Connecting to an Oracle Database
    ... You can also use FrontPage, ... Click Add to Catalog under "Database Connections" ... Put in your Oracle connection string in the custom connections dialog ...
    (microsoft.public.sharepoint.windowsservices)
  • RE: Query Oracle, show results (need help!!)
    ... After the DB connection, put this... ... I am trying to log into an Oracle database, ... Prepare the SQL statement for running and it'll be stored in Oracle buffer ...
    (perl.beginners)
  • ADO connection to Oracle
    ... the runtime version, however, the program terminates with no error ... The program always stops at the connection to the database. ... connection is made using generic OLE DB, not the Oracle data provider. ...
    (microsoft.public.vb.database.ado)
  • Re: How to use tnsping programmatically
    ... database is there. ... the need is to avoid attempting the connection if the Oracle instance ... Simply because you can tnsping the listener doesn't mean the database ... of connectivity/bandwidth on this connection. ...
    (comp.databases.oracle.misc)