Re: Help! Installing Personal Oracle 7 & Developer/2000

David Gilks <myjxfr_at_echidna.stu.cowan.edu.au> wrote in article <342A3ECB.241E418E_at_echidna.stu.cowan.edu.au>...
> I am trying to get Developer/2000 on Windows 95 to work (installed from
> the CD in the Oracle Unleashed book). I have also installed Personal
> Oracle 7 (also on the CD) to act as the database.
> The problem is that the Developer/2000 programs (e.g. forms & reports)
> can't access the database and I get a ORA-03121 error message when I try
> to connect.

03121, 00000, "no interface driver connected - function not performed"

As SQL*Plus is working, it means that SQL*Net has been correctly installed. I think the problem is with the PATH.

Check if your AUTOEXEC.BAT file includes C:\ORAWIN95\BIN in the PATH, e.g. PATH=%PATH%;C:\ORAWIN95\BIN Windows need to be able to load the required DLLs for an application. By default Windows will look in the C:\WINDOWS and then the C:\WINDOWS\SYSTEM directory. If it can't find the DLLs there, it tries the directories specified by the PATH variable.

Most Oracle-based software do not know where the Oracle DLLs are located. Thus, when Windows try and find the DLLs it can't - this results in the application giving the above ora error.

Hope this solves your problem. :-)

regards,
Billy Received on Fri Sep 26 1997 - 00:00:00 CDT