Home » SQL & PL/SQL » SQL & PL/SQL » ORA - 03121 : no interface driver connected - function not performed
ORA - 03121 : no interface driver connected - function not performed [message #188803] Mon, 21 August 2006 13:50 Go to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Dear all,

When I connect to Sql*Plus it connects but when I try to Connect D2k Forms , it says the following Error like " ORA - 03121 : no interface driver connected - function not performed "
Guide to solve this

Regards,
Ashutosh Trivedi
Re: ORA - 03121 : no interface driver connected - function not performed [message #188983 is a reply to message #188803] Tue, 22 August 2006 12:00 Go to previous messageGo to next message
shubha456
Messages: 5
Registered: August 2006
Location: Florida
Junior Member
This message occurs usually because the Net8 driver is not loaded into memory or there is a mismatch of the version of the driver. A user program linked with an obsolete library may also cause this message. Only programs provided by Oracle Corporation should use this interface
Re: ORA - 03121 : no interface driver connected - function not performed [message #188997 is a reply to message #188983] Tue, 22 August 2006 13:16 Go to previous messageGo to next message
ab_trivedi
Messages: 460
Registered: August 2006
Location: Pune, India
Senior Member
Thanks for response but yaar u did not told me about how to rectify the problem ...
Re: ORA - 03121 : no interface driver connected - function not performed [message #189138 is a reply to message #188803] Wed, 23 August 2006 06:13 Go to previous message
rathish123
Messages: 3
Registered: August 2006
Location: Oman
Junior Member
Cause:[/B]
This error indicates that Oracle does not know which database to connect to.

Possible remedies:
Specify the TNS alias to use as part of the connection string.

In order to connect to a database without specifying an explicit TNS alias (i.e. setting it 'by default') either:

set the environment variable ‘LOCAL’ to the required alias.

Set the registry value ‘HKEY_LOCAL_MACHINE \ SOFTWARE \ ORACLE \ LOCAL’ to the required alias.

If the workstation has not been rebooted since Oracle client was installed then try rebooting it now.

Rathish
Previous Topic: SQL QUERY USING DECODE FUNCTION
Next Topic: Parameter type in a package
Goto Forum:
  


Current Time: Fri Dec 09 15:17:39 CST 2016

Total time taken to generate the page: 0.15639 seconds