| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Oracle ODBC Driver Errors
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Free XML ODBC driver for EXCEL | Excel Discussion (Misc queries) | |||
| I try to download a spreadsheet and get a odbc driver manager err | Setting up and Configuration of Excel | |||
| Oracle odbc | Excel Discussion (Misc queries) | |||
| ODBC Driver/Import Data | Excel Discussion (Misc queries) | |||
| xl odbc driver, Excel 2003 | Setting up and Configuration of Excel | |||
Hybrid Mode
