Sage 100

 View Only
  • 1.  Sage 10o ODBC Driver

    Posted 05-04-2020 13:33
    Does anyone know how to setup the Sage 100 ODBC driver without installing Sage 100 on the system?

    ------------------------------
    Robert Wood
    DDF Consulting Group, Inc.
    Ocala FL
    352-615-5898
    ------------------------------


  • 2.  RE: Sage 10o ODBC Driver

    Posted 05-04-2020 13:39
    Administrative Tools / ODBC Data Sources. Assuming that's what you are asking. You will need to enter the settings from a PC that already has it installed

    ------------------------------
    Kenny Daniel
    Technoclarity, Inc.
    ------------------------------



  • 3.  RE: Sage 10o ODBC Driver



  • 4.  RE: Sage 10o ODBC Driver

    Posted 05-04-2020 13:57
    Interesting, @Michelle Forsey - I've never done the reg entries before, just created the ODBC entry - but maybe the machine has always actually had Sage installed at some time and then uninstalled but left the reg entries?  Hm.​

    ------------------------------
    Beth Bowers
    Mom to Samson, Peanut, ChiChi, Canton, Cagney and Daisy (NO Oxford comma - shriek!)
    Beth Bowers
    269-445-1625
    ------------------------------



  • 5.  RE: Sage 10o ODBC Driver

    Posted 05-04-2020 14:01
    @Beth Bowers - I honestly don't think I have ever done the regedit either, but I do register the .dll files as it seems to help with  ​System DSN's. The only time I've ever had to do this is for Sage Alerts and Workflow though... So maybe it depends on the application?

    ------------------------------
    Michelle Forsey
    Eide Bailly, Inc.
    801-456-5470
    ------------------------------



  • 6.  RE: Sage 10o ODBC Driver

    Posted 05-04-2020 17:03
    Never knew you could do it without the client.  Interesting good to know.   But it does seem like installing the client is a tad bit easier...

    ------------------------------
    Jeff Schwenk
    FORMER 90M Board Member
    Bottomline Software, Inc.
    Waynesboro VA
    540-221-4444
    ------------------------------



  • 7.  RE: Sage 10o ODBC Driver

    Posted 05-05-2020 01:12
    @Jeff Schwenk seems like a no brainer to me but the customer wants to set it up and doesn't want the Sage client installed on the server they will be using to read the data. ​

    ------------------------------
    Robert Wood
    DDF Consulting Group, Inc.
    Ocala FL
    352-615-5898
    ------------------------------



  • 8.  RE: Sage 10o ODBC Driver

    Posted 05-05-2020 01:11
    Thanks @Michelle Forsey​! I couldn't find that myself for some reason.

    ------------------------------
    Robert Wood
    DDF Consulting Group, Inc.
    Ocala FL
    352-615-5898
    ------------------------------