Re: Connecting to Oracle Database

On Wed, 19 Nov 1997 13:56:15 -0500, Paromita <paromita_at_mail.com> wrote:

>Hi,
> I have recently loaded Personal Oracle and Developer 2000 on my PC.
>My problem is that whenever I try to connect to the database I encounter
>the error
>ORA- 03121 :No Interface Driver Connected Function Not Performed.
> I just can't figure out what is to be done. I would really appreciat
>any help/advice.
>Thanks.
>---------------------------------------------------------------------
>
What are you using for the connect string and what version of the Oracle Server are you using. Here are some examples of what you should be using.

For Personal Oracle 7.x you should either use

a) <Nothing - leave it blank>
b) "2:"  (for a local connection via the two-task driver)
c) "Beq-Local" for a local connection via the bequeath adapter.

For Personal Oracle 8.03 you should use: a) <Nothing - leave it blank>
b) "Beq-local:

If you do not have a database alias of Beq-Local established, you can create one by running the SQL*Net Easy Config Program and simply do not add an alias. This will create a default TNSNAMES.ORA in your %ORACLE_HOME%\NETWORK\ADMIN (for Oracle 7.x) or %ORACLE_HOME%\NET80\ADMIN (for Oracle 8.x) This file will have several default connections including one to the Bequeath Adapter (for local connections)

Oracle 8.x no longer supports the two-task driver so using Beq-Local is the only way to go. This is the method that I recommend to ensure compatability for future releases of Oracle.

If you have any comments, try sending a copy to my email address directly as I do not check this list that often.

Take Care and good luck.

Robert Clevenger Received on Thu Nov 20 1997 - 00:00:00 CET