Hi, landscape1.
Allow me to help and provide you some insights about the SQL Anywhere Network Server issue in QuickBooks Desktop.
Accessing a SQL Anywhere server using a database file that is located other than on the machine where the server is running is possible, but not in all situations. The following lists some of the architectures you may be considering for use with your SQL Anywhere database.
There are two main requirements for vendors of SAN/NAS hardware/software which determine whether or not SQL Anywhere will function properly:
- The order of file writes is guaranteed. This means that if the server says write A, then write B, the SAN/NAS guarantees that A is written to the physical medium before B. Additionally, on Windows, Microsoft guarantees that a call to SetEndOfFile(...) followed by FlushFileBuffers(...) is sufficient to force the file metadata to the physical medium. We require those same semantics to be respected by a SAN/NAS.
- When a writen request is issued in this environment, the write has actually been completed to the physical medium (not buffered by the operating system or the drive's internal cache) when the SAN/NAS returns from the right call. This is generally true if point 1) above is enforced.
I can pass along all the issue you have to the appropriate channels so you're able to reach a point of resolution as quickly as possible.
I know you've already called in. However, I still suggest getting in touch with our QuickBooks Desktop Support to have this re-investigated. Our phone support has the appropriate looks, like screen sharing, and they can take a better look at this.
- Within your QuickBooks Desktop, click Help at the top menu bar.
- Click Contact us.
- To route you to the correct support expert, we need to know what type of question you have. Give a brief description of your issue and click Continue.
- We’ll provide you a few options. You choose which one is best for you
You may find this article helpful: QuickBooks Desktop Enterprise System Requirements.
Feel free to hit Reply below if you have additional questions about the SQL Anywhere Network issue in QuickBooks Desktop. I'll be around to help.
