Sage 100

 View Only
  • 1.  How To Install the Sage 100 64-bit ODBC Driver for

    Posted 06-05-2014 23:28
      |   view attached
    How To Install the Sage 100 64-bit ODBC Driver for Version 4.50 and Less

    Attachment(s)

    zip
    64-bit-ODBC.zip   532 KB 1 version


  • 2.  RE: How To Install the Sage 100 64-bit ODBC Driver for

    Posted 06-05-2014 23:29
    In case you are interested here are the steps: Carefully perform the following steps on each 64-bit machine that you need the 64-bit ODBC driver installed on (e.g. Windows 7 64-bit PC or Server 2008 R2). This is ideal when running 64-bit applications that cannot 32-bit ODBC connections to Sage 100 (e.g. Any SQL Server 64-bit edition). ** Note: If you are on version 2013 or 2014 these steps are not necessary. Just select Autorun from the \mas90\Wksetup folder and choose the 64-bit ODBC Driver installation. However you may still want the 3 DLLs (version 4.40.0004) mentioned in Step 2 if the installer lays down the old version 4.40.0002. 1. As a prerequisite install the Microsoft Visual C++ 2010 Redistributable Package (x64) if it is not already installed. One way to find out is look in C:\Windows\System32 folder for the msvcr100.dll file. If not found, then it is not installed. Click on this link to download and install this package. It supports 64-bit versions of Server 2008, Server 2008 R2, and Windows 7. http://www.microsoft.com/en-us/download/details.aspx?id=14632 2. Unzip the attached file to a temporary folder. 3. Copy the 3 DLLs into C:\Windows\System32 folder These DLLs are based on version 4.40.0004 which is a bug fix from the 4.40.0002 version shipping with v2013 that causes ""catastrophic error"" when doing SQL Server Linked Server queries. 4. Copy the pvxsec64.dll to the server's \mas90\Home folder 5. Overwrite the pvodbsec.ini file in server's \mas90\Home folder with this one OR edit the existing pvodbsec.ini and add this line: DLL64=.\pvxsec64.dll 6. Merge the 5 .reg files into the registry. In other words, just double-click the .reg files one at a time and click OK each time at the message box that appears. 7. At this point you can click on Start and type ODBCAD32 and press Enter. This will bring up the 64-bit ODBC Administrator (from c:\windows\system32). Under the User DSN tab the SOTAMAS90 DSN will be found. If you click Configure you will not receive the setup routines error anymore. Under the System DSN table you will see v450PU6Silent has been created. This is a Silent Connect DSN. You can either edit this to suit your needs or even better create a new one for yourself.


  • 3.  RE: How To Install the Sage 100 64-bit ODBC Driver for

    Posted 06-06-2014 03:49
    Thanks - great info. Added to Evernote. Anyone not subscribing to our Sage 100 KB Evernote notebook can contact Robert to be added - robertw@ddfcgi.com


  • 4.  RE: How To Install the Sage 100 64-bit ODBC Driver for

    Posted 06-19-2014 00:44
    Based on tonight's new discovery, added a prerequisite to the steps above and updated the Sage 100 KB article in Evernote with the same info. Apparently the 64-bit ODBC driver from Sage 100 2013 was created using Visual Studio and therefore if you install it on a 4.50 or previous system it requires installation of Visual C++ 2010 Redistributable Package (x64).


  • 5.  RE: How To Install the Sage 100 64-bit ODBC Driver for

    Posted 06-21-2014 09:26
    @AlnoorCassim at step 5 is that the server or the workstation?


  • 6.  RE: How To Install the Sage 100 64-bit ODBC Driver for

    Posted 06-21-2014 09:32
    @MoiraGoggin - The server


  • 7.  RE: How To Install the Sage 100 64-bit ODBC Driver for

    Posted 06-21-2014 09:33
    Thanks should have read step 4 more carefully...