Re: Solution to Oracle SQL Net <-ODBC-> MS Active Server Page (ASP)

 hmmm I had the exact opposite experience: My first application connected from MY workstation to MY workgroup database on MY
workstation: it worked.

When putting the asp files on THE WWW-server, connecting to THE database on THE database server: The thing did not work.

I now use Oracle objects for Ole in my asp scripts: This seems to work most of the time
(It's not perfect). So now the time has come to roll out the big guns: Write an ISAPI extention that connects to Oracle using OCI...(deo volente)

hchang_at_cortex.net wrote in article <878598178.24781_at_dejanews.com>...

>Hello,
>
> Our team just recently found a solution to a problem that was seen
>reported on the newsgroups. Basically, the problem is that when
>attempting to connect to a DB from an ASP page to a Oracle server,
>especially an Oracle DB server that is installed on the *SAME MACHINE* as
>the MS IIS ASP Server, You get an error saying:
>
>ERROR: ORA 12203: TNS: Unable to connect to destination
>
> The problem exists only if the DB server is on the same machine as the
>web server -- The ASP page works fine if the two server programs are on
>different machines (i.e. talking thru SQL*Net and TCP/IP)
>
> It turns out that in order to solve the problem, you have to go to the
>ODBC control panel in NT, select the affected DSN, and configure it such
>that SQL*Net connect string is empty. This tells the SQL*Net driver to
>use default local connection.
>
>Hon Chong Chang
>Software Engineer
>Group Cortex, Inc.
>
Received on Wed Nov 05 1997 - 00:00:00 CET