Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Oracle client and networking components missing (Read 4293 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Oracle client and networking components missing
07.04.06 at 10:42:15
 
Jason from Canada asked the following question.
 
Question:
I was trying to use it to query an Oracle 7 database, but have not been able to successfully link up.  Is it because the
oracle database is older than version 8?
 
When I go under connect, and it asks to install the 0040 driver.  Where does that come from?  
 
I tried to set up a connection using the ADO driver for Microsoft SQL, but it did not connect when I entered the username password and database name.  
 
I also received the following message:
Test connection failed because of an error intialising the provider. Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3. or later client software installation.
Provider is unable to function until these components are installed

 
Why not give SQL*XL a try today.
SQL*XL: SQL Excel software

Download SQL*XL now!


Answer:
Oracle 7 should be fine to connect to.  
 
To start with, the ADO driver for Microsoft SQL will not work to connect to Oracle. This driver/provider is for Microsoft's SQL Server. Always use the driver/provider specific for your database.
 
The message about the missing Oracle client is the key to your problem. To access an Oracle database you must install the Oracle Client software or you can also use the Oracle Instant Client (IC). The Oracle IC is more difficult to install but it is a very minimal download. You can download the Oracle client from Oracle also. This is a quite hefty download. If you have an Oracle Client CDROM that would be best to use.
 
I have just summarised Oracle database connection specifics in this topic today. Perhaps you want to have a read of that topic too:
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1130748978
 
References:
SQL*XL product page: Linking Excel to databases
  http://www.oraxcel.com/projects/sqlxl
Connecting Excel to various database types:
  http://www.oraxcel.com/projects/sqlxl/help/techniques/connecting/index.html
Back to top
 
« Last Edit: 22.11.09 at 23:29:34 by Gerrit-Jan Linker »  

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Re: Oracle client and networking components missin
Reply #1 - 08.04.08 at 22:05:59
 
Question
I have difficulty in connecting to the database server which is located on the network.
An error message is reported " Oracle(TM) and other network components are not  
found ".
Is this s/w meant for running client and server apps on the same workstation
 
Answer
Yes the Oracle client is needed on the PC. However you can try to run without a full Oracle client. You can use the OIC: Oracle Instant Client. This is a small set of files that just need copying and not installing.  
 
See:
How to connect to Oracle without installing the Oracle Client software  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1147858931  
Oracle Instant Client (No Oracle Home) tnsnames  
http://www.oraxcel.com/cgi-bin/yabb2/YaBB.pl?num=1169739823
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
jamescliff
YaBB Newbies
*


I Love SQL*XL

Posts: 1
Re: Oracle client and networking components missin
Reply #2 - 27.11.08 at 09:05:54
 
Why not trying Oracle License Compliance tool latest released Version 1.10 of http://www.lime-software.com  Smiley
Back to top
 
 
  IP Logged
Pages: 1