Re: Local Connection WITHOUT SQL net, possible?

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/09/27
Message-ID: <342D9A2E.3110@postoffice.worldnet.att.net>#1/1

You have to set two environment variables, ORACLE_HOME and ORACLE_SID, before running your application. ORACLE_HOME is usually C:\ORANT and ORACLE_SID is ORCL (unless you changed the default SID to another value).

To see if these two variables are set (and if not to set them), do this:

My Computer->Control Panel->System->Environment

The dialog box shows the environment variables that are currently in effect for the whole system and the ones that are set for the logged-on user only. If ORACLE_HOME and ORACLE_SID are not listed there, add them.

After this, you should be able to connect without using @<service_name> in your connect string, i.e. username/password should be enough.

Hope this helps.

Michael Serbanescu

---

Paul Mahler wrote:
>
> I am running NT 4.0 with Oracle 7.3.
>
> I am running my application on the server.
> The documentation makes clear how to connect via SQL net. Is it possible
>
> to make a direct connection from the application running on the server
> to the instance of Oracle running on the server WITHOUT using
> SQL*NET???
>
> Thanks In Advance,
>
> --
> Paul Mahler
> Data Based Systems, Inc.
> email: pmahler_at_databased.com
>
> -----BEGIN PGP PUBLIC KEY BLOCK-----
> Version: 2.6.2
>
> mQCNAzN/SC8AAAEEAMCuCCh/91S1tpCnuVKPprNfs1UACh9bMfDCJ6qmzjM9RA0b
> 4qUX/7QC8a8f/7weRYKdwBuejx2mJuOzy32LDuwnyFU3hexTBplotAS67M4JOnV2
> YwO/OJGzW5rA8RTYIGx75c7fmG7gCJbWBIx2YbWlJaTZlGoUGZ14WfWZVswhAAUT
> tCZQYXVsIFMuIE1haGxlciA8cG1haGxlckBkYXRhYmFzZWQuY29tPg==
> =ei0y
> -----END PGP PUBLIC KEY BLOCK-----
>
> ---------------------------------------------------------------
>
> Name: vcard.vcf
> Part 1.2 Type: text/x-vcard
> Encoding: 7bit
> Description: Card for Paul Mahler
  Received on Sat Sep 27 1997 - 00:00:00 CDT