This setup came after the fact.
The actual setup of the databases, connectivity, DSNs, and more will be in a separate post when we have a little more time.
For now, we had the following error on every workstation:
Sage Accpac ERPA search for said Solution ID turned up nothing.
Version mismatch. Two Microsoft support files (SQLSRV32.DLL and ODBCBCP.DLL) are different versions. Please refer to Solution ID 22331 for more information
Since we were working with a SQL 2005 installed database, the thought was that something within Accpac was expecting an older SQL version, or some files were updated while others were not.
So, we searched the server and found the following files:
- SQLSRV32.DLL = Version 2000.86.1830.0
- ODBCBCP.DLL = Version 2000.86.1830.0
- SQLSRV32.DLL = Version 2000.85.1117.0
- ODBCBCP.DLL = Not Found
Both files were found under %windir%\System32 on the server.
We copied the SQLSRV32.DLL off the share to the same %windir%\system32 location on the workstation after making sure Accpac was shut down properly.
We then tried to run Accpac and received the same Version Mismatch error.
So, we copied the ODBCBCP.DLL file off of the server to the same share location. We then copied the file from the share to the %windir%\System32 on the workstation.
We fired Accpac up again, logged on to the company file and we were connected successfully.
Here is a screen shot of what both the server and the workstation file compare after completing the file copy to the workstation:
By the way, while searching for the solution, we came upon one so-called solution site promising a video of it. We were invited to install an ActiveX component before we could view the video though. We were not permitted to close the Tab that the site was in nor were we permitted to click the X to close the browser. That browser and its tabs could only be shutdown via the Task Manager and an End Task. As always, Internet "Street Smarts" are important!
Correct file versions on both the Server and Workstation
Microsoft Small Business Specialists
*All Mac on SBS posts are posted on our in-house iMac via the Safari Web browser.