I got a problem in setting up a DSN in order to access Oracle database which is at Server. When I click Microsoft ODBC for Oracle in setting up DSN at 32 bit odbc, I get the following error:
"the oracle(tm) client and networking components were not found. These components are supplied by oracle coporation and are part of the oracle version 7.3(or greater) client software installation. You will be unable to use this driver until these components have been installed"
Another thing is I was able to connect to my server using SQL Plus editor. I tried installing drivers and client software a number of times but I get the same error. Anyone Please help me out in this. I really appreciate u'r help in advance.
My System Specifications:
OS: Windows 98 in a LAN with 1GHz Processor and 20GB free hard disk.
Local: Oracle 8.1.7 Client
Server: Oracle 8.1.7
I would also add c:\oracle\oracle81 to the path statement )and reboot)check by typing path at the c prompt. I have encountered this problem several times, and each time there was a path reference problem.
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Subquery in Oracle:
Sub queries are one of advance queries in oracle.
Types of advance queries:
• Sub Queries
• Hierarchical Queries
• Set Operators
Sub queries are know as the query called from another query or another subquery. It can …
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 video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.