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

From: Jeff Cochran (jeff.nospam_at_zina.com)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 14:33:07 GMT

On Mon, 16 Aug 2004 18:24:26 -0700, "Thomas"
<anonymous@discussions.microsoft.com> wrote:

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

Have you tried OLEDB? Since ODBC is deprectaed it makes sense to do
so.

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

That doesn't mean much.

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

Are you signed in as the same user that the ASP app is running under?

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

You still haven't posted a probelm.

>How do you have your clients connecting the Oracle
>databases?

OLEDB.

>Did you use a tool to create your database
>connection?

Notepad works fine.

>Did you script your connection string by
>hand?

The real question is: Have you? And what might that string be? And
what error might it produce?

>Your help and comments are welcome.

But yours are *needed*. Tell us:

Exactly what connection you're using
Exactly what error you're receiving
Exactly what even log entry you find
Exactly what is or isn't happening that you expect or expect not to
happen.

Give us something to go on. So far we know it worked as written on
IIS5/W2K and it doesn't work as written on IIS6/Server 2003. From
those details it could simply be that when you try to use it on IIS6
your roommate smacks you with a brick and knocks you unconscious.

Jeff

Relevant Pages

  • Re: Location of linked table username/password
    ... I use this procedure to re-create links to Oracle. ... Public Function LinkOracleTables(strDSN As String, strSchema As Variant, ... Dim dbODBC As Database, strConnect As String, strSQL As String ... Exit Sub ...
    (microsoft.public.access.externaldata)
  • Re: Query Oracle from Excel
    ... You will need the Oracle client sofware installed on the PC you're running ... What exactly is DBDataProvider and DBDataSource? ... Global prmUsername As String ... Dim adoConn As New ADODB.Connection ...
    (microsoft.public.excel.programming)
  • RE: ORACLE DRIVER
    ... Subject: ORACLE DRIVER ... DBI - is the perl module to handle all the request of the database, ... So is there any free Oracle ODBC driver for Linux? ...
    (perl.dbi.users)
  • Re: How to query a string in Hex or byte format
    ... > between the database server and the code page used for the display on ... so how can I query a string such as a person's name ... The NLS setting for the Sun OS on my Oracle client machine is en ...
    (comp.databases.oracle.server)
  • Re: Fastest String search
    ... I have to query the database with the string from text file. ... By this I mean writing your own Binary File Access method and reading the Oracle database records without using any database engine. ...
    (microsoft.public.dotnet.languages.vb)