ODBC Error: Data Source name Not Found and No Default Driver Specified

  • Thread starter Thread starter Alex
  • Start date Start date
A

Alex

Hi everyone,
When trying to query a SQL database via Excel and when
trying to refresh the information within Excel, I receive
the following error:

ODBC DRIVER MANAGER: Data Source Name Not Found and no
Default Driver Specified.


Does anyone know what this is and how to fix this?
Thank You!
 
[This followup was posted to microsoft.public.excel.misc and a copy was
sent to the cited author.]

In addition to Rich Wallach's suggestion, consider using MS Query to
create a query (Data | Get External Data > New database query...). Once
done, check the SQL syntax in MS Query itself. That should give you
necessary database access/file name constructs.

--
Regards,

Tushar Mehta
MS MVP Excel 2000-2003
www.tushar-mehta.com
Excel, PowerPoint, and VBA tutorials and add-ins
Custom Productivity Solutions leveraging MS Office
 
Back
Top