Sage 100

 View Only
  • 1.  Can Intelligence be set up to use the CS ODBC Driver for better performance?

    Posted 09-04-2024 13:30

    That's my question. Can Intelligence be set up to use the CS ODBC Driver for better performance?

    Thanks,

    Karen



    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    kolane@asifocus.com
    559-448-0900
    559-577-4142
    http://www.asifocus.com
    ------------------------------


  • 2.  RE: Can Intelligence be set up to use the CS ODBC Driver for better performance?

    Posted 09-04-2024 14:33

    I do not think so.

    In the connector you have the connection properties and there is a section for the Extended Properties. This is showing the connection for a DSN-less connection and isn't pulling your SOTAMAS90 DSN info which contains the CS ODBC settings when turned on. It is getting the info from Sage which uses the SOTA.INI or the path you execute Sage 100, if you are Standard. It sends it your user and password and Company code you are in. Premium has different System connection specific to SQL. The connection properties change when you log in each time so if you were to change the setting to force it to CS odbc for Advanced, it would blow it away when you log in next. Since it isn't using the DSN and is creating one on the fly, I do not see how you could set it up to use CS ODBC, unless you create your own system connection. Which you can't as far as I am aware. It might be better to just take them to premium if that is a requirement.

    Maybe I am missing something though.



    ------------------------------
    Todd Martin
    MBA Business Software
    https://www.mbabsi.com
    ------------------------------



  • 3.  RE: Can Intelligence be set up to use the CS ODBC Driver for better performance?

    Posted 09-05-2024 14:18

    Got it. Thank you so much, @Todd Martin!



    ------------------------------
    Karen O'Lane
    Accounting Systems, Inc. (ASI)
    kolane@asifocus.com
    559-448-0900
    559-577-4142
    http://www.asifocus.com
    ------------------------------