+ Reply to Thread
Results 1 to 1 of 1

ODBC setup on Windows 10

  1. #1
    Registered User
    Join Date
    08-27-2013
    Location
    UK - East Coast
    MS-Off Ver
    Excel 2010
    Posts
    26

    ODBC setup on Windows 10

    Evening all,

    We have just moved over to Office 365 on Windows 10 Enterprise 64Bit and have had an absolute nightmare getting ODBC setup and functioning on these machines. I will add I have had very little to do with this as the machines are locked down and only admins can sort these things out.

    After a good few weeks of them messing around they finally got it all setup and functioning within Excel.

    Basically we are pulling data from our live stock system into a friendly environment such as Excel to create reports or run sheets.

    The only outstanding issue they are having is that when you first start up a sheet and request the pull of data the user is prompted to select the Machine Data Source, followed by the login details for the source. You mearly need to click OK on each instance, however we would prefer it if this prompt does not appear as a user can easily screw up the login details for the machine. (See attached pics)

    So is there anyway to stop these prompts? This was never an issue on the Win 7 machines, I know that from what they said a lot of the issues were because the machines are now 64bit, whereas we use to use 32bit machines. (Driver issues)

    Any assistance is greatly appreciated.
    Attached Images Attached Images

+ 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. [SOLVED] how to insert modified page setup in print setup
    By JEAN1972 in forum Excel General
    Replies: 1
    Last Post: 01-11-2019, 06:02 AM
  2. [SOLVED] Use ODBC connection without setting it up in ODBC administration
    By ExcelGal in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-18-2012, 09:59 AM
  3. ODBC setup, SQL server & Excel VBA
    By Lifeseeker in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-17-2012, 02:45 PM
  4. MS Query using ODBC - ISAM Error message in Windows 7
    By Mike_VW in forum Excel General
    Replies: 0
    Last Post: 03-17-2011, 05:52 PM
  5. Replies: 0
    Last Post: 11-28-2009, 01:28 AM
  6. 1004 general ODBC error office 97 windows xp
    By astro in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-15-2008, 03:41 PM
  7. Windows XP, Excel 2000: ODBC driver for Visual FoxPro tables
    By Arvi Laanemets in forum Excel General
    Replies: 0
    Last Post: 01-24-2005, 05:06 AM

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