Return-Path: 
 <users-return-13726-apmail-httpd-users-archive=httpd.apache.org@httpd.apache.org>
Delivered-To: apmail-httpd-users-archive@httpd.apache.org
Received: (qmail 276 invoked by uid 500); 9 Sep 2002 15:57:08 -0000
Mailing-List: contact users-help@httpd.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@httpd.apache.org
list-help: <mailto:users-help@httpd.apache.org>
list-unsubscribe: <mailto:users-unsubscribe@httpd.apache.org>
list-post: <mailto:users@httpd.apache.org>
Delivered-To: mailing list users@httpd.apache.org
Received: (qmail 264 invoked from network); 9 Sep 2002 15:57:08 -0000
Received: from saturn.bt.com (HELO mbibipnt08.HC.BT.COM) (193.113.57.20)
  by daedalus.apache.org with SMTP; 9 Sep 2002 15:57:08 -0000
Received: by mbibipnt08.nat.bt.com with Internet Mail Service (5.5.2653.19)
	id <SSRR8BMX>; Mon, 9 Sep 2002 16:57:21 +0100
Message-ID: <1D34616EBF08D511B82300508BF996020189D438@mbibipnt11.nat.bt.com>
From: farshid.dabesh-khoy@bt.com
To: users@httpd.apache.org
Date: Mon, 9 Sep 2002 16:57:18 +0100 
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
Subject: RE: [users@httpd] Connecting to an Oracle database via Apache

Gilles,

I can connect to it from SQLplus.

I still cant connect through the asp page. The question is, how does the DSN
get resolved to the TNSnames? 

I have the ODBC drivers installed already, do I need anything else? i.e.
ODBC environment

I know the topic is steering away from apache, but any help would be great.

thank you

Farshid

-----Original Message-----
From: Gilles Gros [mailto:gillesg@whitepj.com]
Sent: 09 September 2002 15:54
To: users
Subject: RE: [users@httpd] Connecting to an Oracle database via Apache


First of all,

Can you connect directly to the database NOAH thru sqlplus ?

If not check the tnsname and eventually the listener of Oracle
configuration.

Gilles

> -----Original Message-----
> From: farshid.dabesh-khoy@bt.com [mailto:farshid.dabesh-khoy@bt.com]
> Sent: Monday, September 09, 2002 7:39 AM
> To: users@httpd.apache.org
> Subject: [users@httpd] Connecting to an Oracle database via Apache
>
>
> Dear all,
>
> I have all the necessary apache components for connecting to an Oracle
> database installed, and I am running .asp pages. One of the .asp
> pages tries
> to connect to an Oracle database on our systems.
>
> However I am guessing that it can not resolve the DSN name
> specified in the
> .asp file.....
>
> oRS.OPEN sqlTEXT, "DSN=noah; UID=noah; PWD=noah"
>
> ..... as in how does it know where "noah" is?
>
> is there a way of providing apache with information on how to resolve the
> DSN name specified?
>
> is there like a TNSnames.ORA file or equivalent for Unix???
>
> I am running apache 2.0.36, on solaris2.8
>
> any help would be greatly appreciated.
>
> Farshid
>
> ---------------------------------------------------------------------
> The official User-To-User support forum of the Apache HTTP Server Project.
> See <URL:http://httpd.apache.org/userslist.html> for more info.
> To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
>    "   from the digest: users-digest-unsubscribe@httpd.apache.org
> For additional commands, e-mail: users-help@httpd.apache.org
>
>


---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org

---------------------------------------------------------------------
The official User-To-User support forum of the Apache HTTP Server Project.
See <URL:http://httpd.apache.org/userslist.html> for more info.
To unsubscribe, e-mail: users-unsubscribe@httpd.apache.org
   "   from the digest: users-digest-unsubscribe@httpd.apache.org
For additional commands, e-mail: users-help@httpd.apache.org