I am using a Visual Basic 4.0 application that is using Intersolv ODBC 2.11 Oracle7 drivers to connect to an Oracle 7.2 database. When the application tries to connect through the ODBC driver to the Oracle database I get an ORA-03121 no interface driver connected - function not performed. I am using SQL*Net 2.1 using TCP/IP protocol. I can connect to Oracle from SQL*Net or using the NET*Test utility from Oracle, but whenever I try to connect to the database through the application or using the Intersolv Compass utility I get this ORA-03121 error. Does anybody have any ideas on how this problem could be solved?
The problem that you're likely experiencing is that your PATH statement in your AUTOEXEC.BAT file is missing a pointer to your ORAWIN\BIN directory. From a DOS prompt type "SET" and check your PATH statement.
Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here.
General principle of Oracle compression
Oracle compression is a way of reducing the d…
This post first appeared at Oracleinaction (http://oracleinaction.com/undo-and-redo-in-oracle/)by Anju Garg (Myself).
I will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…