Oracle ODBC connection problem - OracleThe Oracle(tm) client and networking components were not found.?

Answer 1

1st try to restart i hope i will sove problem.

2nd
The error occurs because the Oracle client and networking components are not installed. The computer that is running SQL 7.0 requires the Oracle client and networking components to use MS Oracle provider to connect to an Oracle server.
Back to the top

WORKAROUND
If you are on a SQL Server cluster, you must install Oracle client and networking components on each of the nodes (or computers) that are part of the cluster. The Oracle client software (SQL*Net) is manufactured by Oracle Corporation. This software can be obtained only from Oracle Corporation.
Back to the top

MORE INFORMATION
With Microsoft SQL Server 7.0, you can perform queries against OLE DB providers. You do this by using the OpenQuery or OpenRowset Transact-SQL functions or by using a query with four-part names including a linked-server name. For example:

sp_addlinkedserver 'mylinkedserver', 'product_name', 'myoledbprovider', 'data_source','location', 'provider_string', 'catalog'

SELECT * FROM OPENQUERY(mylinkedserver, 'select * from table1')

SQL Server 7.0 installs Microsoft OLE DB Provider for Oracle. To query a local or remote Oracle server database from SQL Server query that uses the Microsoft OLE DB Provider for Oracle, you must install Oracle client and networking components on the computer that is running SQL Server.

For Transact-SQL code examples on setting up and using distributed queries with an Oracle server search on "Microsoft OLE DB Provider for Oracle" in the index of the SQL Server 7.0 Books Online.


for more information follow link below

Answer 2

This Site Might Help You.

RE:
Oracle ODBC connection problem - OracleThe Oracle(tm) client and networking components were not found.?

Answer 3

We're going to need more information than that.

Let's start with the obvious. Do you have the Oracle client installed on your machine? Have you set up an ODBC connection?

Is this error occurring when you're running a program you've written yourself? A commercial program?

I mean there are literally millions of things it could be and we really have no way of knowing.

Please tell us more.

Answer 4

You may also have the wrong version of the oracle client software for the odbc driver that is attempting to use the oracle connection.

Answer 5

Listen honey; you absolutely have to begin reading the Scripture and praying every single day! The ONLY way to develop the conviction to change is by learning of the Lord. The Holy Spirit WILL accomplish this in you, but you HAVE TO be willing to do what it takes. In the scripture is EVERY thing we need to be daily transformed into the image of Christ Yeshua. Believe me, we want to always pity ourselves because we have this or that problem which seemingly prevents us from living the Christian life. It is a damned LIE from satan! Really!!! Learn to set aside a specific time EVERY day for time alone with the Lord. Take that one dedicated hour and discipline yourself to it; to be resolute that IT BELONGS to the study and prayer unto the Father! I promise you that you will see yourself growing in the knowledge, grace and patience of your salvation! With our earthly relationships, we really require regular communication (fellowship & prayer); and we wouldn't dare think that the relationship would be healthy or work at all if we did not communicate and spend time with this or that person. SO IT IS the same or more so TRUE with God! He desires our time, and more so our hearts! Continue seeking and praying. Get with other Christians for bible study, fellowship and worship. People who are good, honest and who make their walk with God of top priority. He is faithful and just to always HONOR the one who truly seeks a right relationship with Him! I pray you atleast give my advise a fair chance, HE will not leave you comfortless my friend! In Yeshua Christ, Seven