Data Source Name Not Found

andy · External Since: Jul 16, 2007 Posts: 1

I have an Excel spreadsheet with a dozen queries to an Oracle database. I
recently switched PCs. Seveal of my queries do not work on the new PC now.
I get:

"[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified."

It seems that several of these queries may use a data source name that I
have not defined on my new PC. How do I find out what data source name the
Excel query is looking for, so that I can add them? Clicking on the "Edit
Query" button on the External Data toolbar simply gives me the above error.

I'd like to avoing recreating the queries if possible.

Dick Kusleika · External Since: Mar 08, 2007 Posts: 13

On Mon, 16 Jul 2007 13:36:13 -0500, "andy"<noway.TakeThisOut@noway.xyz> wrote:

>I have an Excel spreadsheet with a dozen queries to an Oracle database. I
>recently switched PCs. Seveal of my queries do not work on the new PC now.
>I get:
>
>"[Microsoft][ODBC Driver Manager] Data source name not found and no default
>driver specified."
>
>It seems that several of these queries may use a data source name that I
>have not defined on my new PC. How do I find out what data source name the
>Excel query is looking for, so that I can add them? Clicking on the "Edit
>Query" button on the External Data toolbar simply gives me the above error.
>
>I'd like to avoing recreating the queries if possible.

Andy:

Open up the VBE (Alt+F11)
Open the Immediate Window (Cntl+G)
Type:
?Sheet1.QueryTables(1).Connection
Change Sheet1 and the QT index as necessary. This will print the connection
string, which should tell you the datasource name it's expecting.
--
Dick Kusleika
Microsoft MVP-Excel
http://www.dailydoseofexcel.com