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
Pages: 1