Forums

Resolved
0 votes
Has anyone been able to make this work? I have two customers with ClearOS 6 that have had to switch to using a Windows workstation as the host of the Quickbooks company file, because they received the H202 error when switching to multi-user mode while the ClearOS machine was hosting it. It used to work with QBES 16, and it still works with 17 when the file is in single-user mode.

We are trying to switch back to using the ClearOS machine as a host at one of the clients, because using the workstation to host access for the 7+ simultaneous users is causing lots of other problems that Intuit support doesn't want to help us solve. If I can't make it work I might try installing the Windows version of QB using WINE and host the company file that way, but that seems like a long shot.
Wednesday, August 09 2017, 04:11 PM
Share this post:
Responses (3)
  • Accepted Answer

    Sunday, May 19 2019, 10:09 AM - #Permalink
    Resolved
    0 votes
    Dave,

    File sharing is such a fiddly technology and SAMBA's attempt to mimic Windows is heroic. I wish people making applications that use networking would use more appropriate technology such as SQL or Streaming or HTML or whatever suits the task rather than simply have the hard drive files moved to a file server. 1980's called and they want their file sharing technology back.
    The reply is currently minimized Show
  • Accepted Answer

    Sunday, May 19 2019, 04:43 AM - #Permalink
    Resolved
    0 votes
    In all the times that I have gotten Quickbooks Enterprise to work and all the times that it has failed it was NOT the samba that was the problem but rather the support or lack their of from Intuit.

    The think particular about Quickbooks is that it requires that you run a special service on ClearOS to make it work. This service requires the special 32-bit gliibc and other 32 versions of libraries to function properly. If you are having difficulty getting their service to start, you need these special 32 versions running on 64bit ClearOS.
    The reply is currently minimized Show
  • Accepted Answer

    Saturday, May 18 2019, 01:08 PM - #Permalink
    Resolved
    0 votes
    I realise this is old but highlights a common problem with file sharing Windows programs over SAMBA.
    I have a user with a Lotus Approach database which works fine until a 2nd person opens it. They have to wait 3 minutes before it opens and then 1 minute for every action. I tried everything in smb.conf and flexshares.conf to do with oplocks but it would not resolve. I even ran ClearOS 7 as a VM and two Windows VMs on my Linux Mint box and was able to reproduce the problem.

    In this case the solution was to do a database copy on the files. In rebuilding the databases it must have fixed some hidden corruption because after that it worked fine with no special settings in SAMBA.

    I suggest that if there is some way you can rebuild or reindex your Quickbooks then that might resolve the issue.

    In Lotus Approach the other solution would have been to ODBC to a MariaSQL database but the original app would have needed a lot of tidying up due to lack of indexing and sloppy data integrity. I proved the concept though.
    The reply is currently minimized Show
Your Reply