Oracle ODBC Driver Errors

E

Excel GuRu

Currently we are upgrading to a new version of the Oracle client(from 8.1.7
to 11g). We use an ODBC connection to bring data from Oracle tables into
Excel. When we load the new Oracle client on a workstation, queries created
in the old version of Oracle no longer work.

When we try to refresh the query we get the following error message, it says
"[Microsoft[ODBC Driver Manger] Data source name not found and no default
driver specified"

I think it is referencing the the driver name. If you create a new file DSN
on the workstation, the FILE DSN references "Oracle in OraClient11g_home"
(11g) and not" Oracle ODBC Driver"(8.1.7).

Is there a way to make a general reference to the file DSN so the query
would work on workstations running either Oracle client?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Driver doesn't support the version of ODBC behaviour 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Access 2003 not linked to Oracle 11g 3
How to update list of ODBC Drivers on Oracle Server Setup screen 8
Connection Oracle Web Service Problem 0
Issue with being able to select 64 bit Data Sources in Excel 2007 0
How to connect to an Oracle Database from a Word Macro 1
ODBC-Query with a parameter (by function) 0

Top