Data source name not found , no default driver specified. ODBC, Excel and SqlAnywhere

Posted on 2013-05-21
Medium Priority
Last Modified: 2016-06-16
We import data from a sql anywhere database and everything looks great.
But when i use the refresh button to update the data i get error messege "Data source name not found , no default driver specified" ??

I can refresh the data by selecting the odbc connection to the database that apperas after clicking ok to the error messege.

We need this to work properly,
Question by:cfajilu
LVL 20

Accepted Solution

ltlbearand3 earned 1500 total points
ID: 39193072
What version of Excel are you using?  How is the data imported?  Can you post a sample worksheet?  We really need more information.

In Excel 2010 (or the like) if you click on the Data Ribbon and then click existing connections, does anything show in the existing workbork?  If so, double click on the existing connection and then click on properties.  Click on definition and make sure that all settings are correct.


Author Comment

ID: 39560168
I've requested that this question be deleted for the following reason:

this is solved

Expert Comment

ID: 41656857
Was the solution given by ITlbearand3 solved the problem?  If not, How did you solve the problem?  I have the same problem.

Nevermind - I saw the problem.  ITlbearand3 was right, The connections file was sitting on somebody else computer.   Thank You!!!!

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
This tutorial is about creating a new Microsoft Online User Profile account along with how to transfer your files and settings. You may be faced with this situation if your existing user profile has become corrupted.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question