Re: Fail connecting to Personal Oracle 8.0

Amin Ch. wrote in message <362D3A30.ED0C7955_at_usa.net>... <e-mail copy send to amin_ch_at_usa.net as requested>

>I use Oracle Form Builder version 5.0.5.4.0 and Personal Oracle 8.0 for
>Win 95. But when I try connect to local database in Personal Oracle, the
>connection is failed. I get the following error message :
>ora-3121 : no interface driver connected - function not performed.
>What should I do to resolve this problem??
>From Ms Access, I can connect to Personal Oracle successfully using
>ODBC.
If ODBC works there's no reason why Form Builder should not work. Open the ODBC connection and have a look at the host or connection string. Use the exact same string in Form Builder when trying to connect.

I suspect that you may be using a different connection string (or alias) in Forms which uses a protocol that you have not installed.

If you're not running TCP/IP on your PC, then you should be using the Oracle bequeath protocol. It is basically a direct program (client) to program (Oracle database) connection instead of a program (client) via network (e.g. TCP/IP) to program (database) connection.

To troubleshoot your connections/aliases, use SQL*Net Easy config to maintain (add/modify) the aliases and run the command TNSPING <aliasname> in a DOS window to check if that alias is valid.

regards,
Billy Received on Wed Oct 21 1998 - 05:03:40 CDT