Excel Error Data Source Name Not Found
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site excel data source name not found and no default driver specified About Us Learn more about Stack Overflow the company Business Learn more about excel odbc data source name not found hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss
Data Source Name Not Found And No Default Driver Specified Excel 2013
Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Why Error: “[ODBC Driver
Data Source Name Not Found And No Default Driver Specified Excel 2010
Manager] Data source name not found…”? (works fine on dev environment) up vote 2 down vote favorite 1 I'm encountering problems in my ASP page. This is a login page which checks the user's credentials to the database before it allows access to the main page. I created a debugger page to find out what's the error details and this is the error message: Microsoft][ODBC odbc driver manager data source name not found excel Driver Manager] Data source name not found and no default driver specified. That's the error message I' m encountering on the web server when I'm loging in to the site. The weird thing here is when testing the page locally on my machine (desktop) everything works fine (even with IIS and MSSQL server). I'm also using the same connection string when deploying and testing the page. Please help, any suggestions or comments will be greatly accepted. Thanks, Nhoyti sql-server asp-classic odbc ado share|improve this question edited Dec 1 '11 at 15:36 Joel Coehoorn 248k92440661 asked Jan 26 '10 at 5:09 nhoyti 15114 add a comment| 4 Answers 4 active oldest votes up vote 2 down vote accepted The problem is probably with the ODBC configuration on the Server itself. In other words the connection string [to the ODBC source] is ok (since tested on other server), but it makes reference to a source that is not configured on this particular server. To remedy the problem, open the ODBC Data Source Administrator (typically one of the shortcuts in the "Administrative" tools menu), and check if indeed you have a source (typically a "System
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About
Odbc Driver Manager Data Source Name Not Found And No Default Driver Specified Windows 7
Us Learn more about Stack Overflow the company Business Learn more about hiring developers microsoft odbc driver manager data source name not found and no default driver specified sql server or posting ads with us Super User Questions Tags Users Badges Unanswered Ask Question _ Super User is a question microsoft odbc driver manager data source name too long oracle and answer site for computer enthusiasts and power users. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers http://stackoverflow.com/questions/2137618/why-error-odbc-driver-manager-data-source-name-not-found-works-fine-on are voted up and rise to the top Error when refreshing data from external source in excel. Data source name not found and no default driver specified up vote 2 down vote favorite I have an excel workbook which has an external data source to create a pivot table. This file was sent to me. I can open it up correctly, but when I try to refresh the http://superuser.com/questions/486031/error-when-refreshing-data-from-external-source-in-excel-data-source-name-not-f data I get the following error: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified. As far as I'm concerned, Windows should use the default ODBC driver (odbcad.exe) for the connection. Any idea what might be causing the error when refreshing the data? EDIT: The connection string has DSN, UID, TRUSTED_CONNECTION, APP, WSID and DATABASE fields. EDIT: I set up the ODBC connection, but now I'm getting the following error: [ODBC Driver Manager] The Specified DSN contains an architecture mismatch between the Driver and Application microsoft-excel microsoft-excel-2007 odbc share|improve this question edited Oct 10 '12 at 19:55 asked Oct 10 '12 at 18:54 sazpaz 147119 add a comment| 1 Answer 1 active oldest votes up vote 3 down vote accepted Even thought the ODBC connection information is present in the Excel workbook, an ODBC connection must be established between your PC and the data source in order for the workbook to connect. Not sure what OS you are using, but here is Using the ODBC Data Source Administrator for Windows 7. If you do not know the information to setup the connection, contact your network administrator. share|improve this answer answered Oct 10 '12 at 19:25 CharlieRB
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 15 Oct 2016 09:25:18 GMT by s_ac15 (squid/3.5.20)
sophisticated digital experiences Web content & Customer Journey Sitefinity CMS Build engaging websites with intuitive web content management Application Development, Testing & Deployment DevCraft Leverage a complete UI toolbox for web, mobile and desktop development OpenEdge Build, protect and deploy apps across any platform and mobile device Kendo UI Build rich, smart HTML5 and JavaScript apps for any platform, browser or device Telerik Platform Build mobile apps for iOS, Android and Windows Phone Nativescript Use Angular, TypeScript or JavaScript to build truly native mobile apps Rollbase Rapidly develop, manage and deploy business apps, delivered as SaaS in the cloud Test Studio Automate UI, load and performance testing for web, desktop and mobile Modulus Host, deploy and scale Node.js, Java and .NET Core apps on premise or in the cloud Data Connectivity DataDirect Connectors Optimize data integration with high-performance connectivity Business Rules Management Corticon Automate decision processes with a no-code business rules engine View All Products Solutions Digital Business Transformation Transform your businesses in order to survive in a completely digitized and connected world driven by software innovation. Web Scale Globally scale websites with innovative content management and infrastructure approaches Modernization UX and app modernization to powerfully navigate todays digital landscape Omni-Channel Engagement Content-focused web and mobile solution for empowering marketers aPaaS Fuel agility with ever-ready applications, built in the cloud Enterprise Mobility Faster, tailored mobile experiences for any device and data source New & Trending E-book The Digital Ultimatum: Why Businesses Must Digitally Transform to Survive â€" and Thrive Survey Report The State of Digital Business Support & Learning Support Support Services Knowledge Base Customer Order Management Download Center Services Training Consulting Services Managed Database Offering Learning Documentation Webinars How-To Videos Whitepapers Community Blogs Success Stories Partners Company Login Progress Support Rollbase DataDirect Cloud PartnerLink Telerik Your Account Telerik Platform Global Sites Brazil France Germany Netherlands United States Menu 1-800-477-6473 CONTACT SALES Knowledge Base 000002747 < Back to search results "Data source name not found and no default driver specified" error on connecting using ODBC applicationsPri