+ Reply to Thread
Results 1 to 15 of 15

[microsoft][ODBC Driver Manager] Data source name not found and no default driver specifie

  1. #1
    Registered User
    Join Date
    06-03-2019
    Location
    Manchester
    MS-Off Ver
    MS365
    Posts
    8

    Red face [microsoft][ODBC Driver Manager] Data source name not found and no default driver specifie

    Morning All! I hope everyone had a good weekend!

    This is my first post in the forum, and I hope I have selected the correct area to post it! I wanted to ask a quick question, just to get a feel for what might be wrong, with one of my sheets.

    A little background... I have an amazing guy who creates excel sheets for me - sheets I can import into Sage to save manual processing. I think he must be on holiday, as I haven't had a reply to a query. I reformatted my laptop last month, so haven't used a particular sheet since then, and I am now getting an error message, and I don't know if this is down to the sheets, or an excel update perhaps. I was hoping somebody might be kind enough to point me in the right direction.

    The set up is.. one sheet for data entry - this is just a normal spreadsheet. This gets saved as a TXT file. This TXT file is in a folder which also has an SQL.txt and a Schema configuration setting file (I hope this makes sense to someone!). Once I have saved the data spreadsheet as a TXT, I open another spreadsheet (I think is a Macro, I have to enable content), I right click A2 and refresh.. and this updates with all the new info.

    However, this isn't happening today! I get a message "[microsoft][ODBC Driver Manager] Data source name not found and no default driver specified"

    I am on 64 bit MS Windows 10.0.17763. My excel will be latest MS365 Home version.

    If anyone has any thoughts, I'd love to hear them!

  2. #2
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: [microsoft][ODBC Driver Manager] Data source name not found and no default driver spec

    Hi,
    In your post you mention importing into Sage.
    Are the imports saved as .txt or .csv files then converted to import financials.
    If this is the case, there is no need as you can import direct from Excel using a pre-mapped 'field map'

    Attachment 626929

  3. #3
    Registered User
    Join Date
    06-03-2019
    Location
    Manchester
    MS-Off Ver
    MS365
    Posts
    8

    Re: [microsoft][ODBC Driver Manager] Data source name not found and no default driver spec

    Hi, thanks for your reply! Really appreciate it!

    Its not a simple import sheet. Its a group of files that create the import sheet. It creates sales invoices, purchase invoices and journals from one line of data (and the margin scheme VAT amount). I do know enough about excel to be able to fudge something to import, but it would take a while. So before I start that, I thought I would see if the fix was something and nothing.

    I have clicked your attachment link but it comes back as invalid?

  4. #4
    Forum Expert torachan's Avatar
    Join Date
    12-27-2012
    Location
    market harborough, england
    MS-Off Ver
    Excel 2010
    Posts
    4,295

    Re: [microsoft][ODBC Driver Manager] Data source name not found and no default driver spec

    Attached example of Excel sheet for Audit Trail import.
    Sales/Purchases/Invoices all follow similar import maps.
    These are a one time setup in the Sage import facility.
    No external programs or converters required.
    The data attached has been de-sensitised.
    Capture.JPG
    Capture2.JPG
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    06-03-2019
    Location
    Manchester
    MS-Off Ver
    MS365
    Posts
    8

    Re: [microsoft][ODBC Driver Manager] Data source name not found and no default driver spec

    Hi, thanks for coming back to me.

    It's a bit more complicated than that, with these particular sheets. I use those normal import sheets all the time. One has to have all the data to populate those imports. The sheets I am referring to, create that data - one line of data on the source document becomes 3-4 lines for the import template.

    It has always worked fine, and I think its not the sheets that are the issue. I think that, in reformatting my laptop, something from the registry is now missing. That's my theory at the moment, anyhow! That's said, my previous laptop image had windows and excel on it, nothing special was added...

  6. #6
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Arrow

    Hi !

    I guess some complement was installed on your previous setup so see on Microsoft download website
    or ask to the one who created your SQL VBA code …

  7. #7
    Registered User
    Join Date
    06-03-2019
    Location
    Manchester
    MS-Off Ver
    MS365
    Posts
    8

    Re: [microsoft][ODBC Driver Manager] Data source name not found and no default driver spec

    Bonjour Marc! Merci pour votre réponse!

    I have never added anything special to the computer, just downloaded windows and then Office from the MS website.

    The creator of the sheets has used .xlsx and .txt and a .ini file.

    Hopefully he will be back off holiday before my deadline on Friday!

  8. #8
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: [microsoft][ODBC Driver Manager] Data source name not found and no default driver spec


    So maybe the DSN in the VBA code is not set in Windows or it's a granted access level issue or …

    Perform a web search for « microsoft ODBC Driver Manager Data source name not found » and see within results.

  9. #9
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: [microsoft][ODBC Driver Manager] Data source name not found and no default driver spec

    Without looking at code, bit hard to help you. But as Marc pointed out, it is issue with your connection string, DSN and/or bitness of ODBC and Excel doesn't match (this may be the case if you installed 64bit Office Note: This is separate from your OS bitness).

    Also, check that you have appropriate driver/provider installed on your laptop.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  10. #10
    Registered User
    Join Date
    06-03-2019
    Location
    Manchester
    MS-Off Ver
    MS365
    Posts
    8

    Re: [microsoft][ODBC Driver Manager] Data source name not found and no default driver spec

    Hi again, Marc

    I did start out with a google search but so many different variations came back. They all seem to be related to various commercial software. Mine are just excel and notepad files that talk to each other, they don't link to a piece of software (I import the final data into Sage, but that's very separate). So, I don't know where to go with that one.

    I have an excel file which holds the data. A normal excel workbook - lets say this is FILE A - saved in a main folder

    I save my normal excel workbook as the XXX.txt file - and it just copies the information into TXT - lets say that is FILE B (saved in a subfolder)

    I then open a macro enabled excel work book (FILE C) (saved in main folder). I am supposed to just be able to refresh it. And the TXT information from FILE B appears.

    There are two other files in the sub folder with FILE B. A .ini file that seems to set up columns names, and, another TXT file which seems to be telling the Marco workbook what to do with FILE B's information. A connection document? Would something like this need a special add on? I haven't downloaded anything before, so unless Microsoft have stopped including a standard thing in their latest download, I cant think what it could be? I haven't changed any of the file names

    Seems it may be best to hope the creator returns from holiday before my deadline. Its obviously not a simple issue.

    Thanks anyway
    Last edited by FoxyladyAccountant; 06-03-2019 at 09:46 AM.

  11. #11
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    9,831

    Re: [microsoft][ODBC Driver Manager] Data source name not found and no default driver spec


    If it's the DSN used in code which not exists on Windows side, it's easy to solve like you can see on Web
    (as I do not use Google - not very acurate - no commercial software on my side) …

  12. #12
    Registered User
    Join Date
    06-03-2019
    Location
    Manchester
    MS-Off Ver
    MS365
    Posts
    8

    Re: [microsoft][ODBC Driver Manager] Data source name not found and no default driver spec

    Hi CK, thanks for you reply!

    Where can I find out if I am using 32 or 64 office?

    Love your quote by the way - this is why this spreadsheet was created!! Cos I CBA with doing it all manually!! LOL

  13. #13
    Registered User
    Join Date
    06-03-2019
    Location
    Manchester
    MS-Off Ver
    MS365
    Posts
    8

    Re: [microsoft][ODBC Driver Manager] Data source name not found and no default driver spec

    Does this help at all?..... when I click the ODBC error message, an excel error comes up saying "the following data range failed to refresh: Query for Europa_1" (also seen Europa numbers). I don't think anything we have is called "Europa" (sorry for being such a novice!)

  14. #14
    Registered User
    Join Date
    06-03-2019
    Location
    Manchester
    MS-Off Ver
    MS365
    Posts
    8

    Re: [microsoft][ODBC Driver Manager] Data source name not found and no default driver spec

    Hi CK!

    You were right.. whilst I now have 64bit windows and excel, the spreadsheets were created when I had 32bit excel, so the properties have been updated and all is well. Thanks everyone for your time, I appreciate it's not easy to know whats happened without seeing something!

  15. #15
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: [microsoft][ODBC Driver Manager] Data source name not found and no default driver spec

    You are welcome

    It your issue is resolved. Please mark the thread as solved by using thread tools found at top of your initial post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sybase Connection: Data source name not found and no default driver specified
    By VAer in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 01-20-2017, 12:11 AM
  2. Replies: 5
    Last Post: 08-12-2015, 05:45 PM
  3. Replies: 2
    Last Post: 07-09-2015, 08:34 AM
  4. Error -2147217900: [Microsoft][ODBC Excel Driver] <tablename$> is NOT a valid name
    By basubdd in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 07-06-2013, 11:34 AM
  5. Replies: 0
    Last Post: 03-28-2012, 11:24 AM
  6. ODBC Microsoft Access Driver Login Failed
    By pinkshirt in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-13-2011, 10:50 AM
  7. [SOLVED] Error processing the dimension '[Microsoft][ODBC dBase Driver] To.
    By Catalin in forum Excel General
    Replies: 0
    Last Post: 04-22-2005, 01:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1