Although it may sound unnecessary, the first check is to ensure you have the correct parameters set in your connection method.
- Server: Test using IP address as well as Server name. Also include the Instance name if used. When installing the SAP Business One server on Version 8.8, you can no longer enter (local) or a period (.) for the server name. The name must be a server name or IP address.
- DBType: dst_MSSQL /dst_MSSQL2005 depending if customer is using MSSQL 2000 or MSSQL 2005. Up until Version 2007, the default value for the DBServerType property of the Company object was dst_MSSQL (SQL Server 2000), so you could connect to the DI API without specifying a server type if you were using SQL Server 2000. In Version 8.8, you must specify a server type.
- LicenseServer: ensure it is started and the correct name with port is used e.g. localhost:30000 or TestPC:30000
- DBUserName and DBPassword are set and are correct.
SM_OBS_DLL folder is not updated:
This is the most common solution to errors that occur when connecting to the DI/DTW. When connecting to the DI API the following occurs:
- The SAPbobsCOM connects to the server and requests the OBServer.dll (stored in the SBO-Common database)
- The OBServer.dll is loaded from the server into process memory and stored in the temp folder on the local system
- Via the OBServer.dll it accesses the company database
This means the OBServer.dll is downloaded only during the first connection and uses this each time it wants to connect there after. When you upgrade your DI and there has been a database upgrade then the new version of the OBServer.dll will be downloaded automatically to the SM_OBS_DLL folder in the temp folder. If there has only been a client upgrade then the SBO-Common version is unchanged so the OBServer.dll will not be replaced since it doesn’t detect the change.
Therefore after each upgrade we recommend that you do the following:
- Go to Start -> Run and type %temp%
- Locate the folder SM_OBS_DLL
- Delete or rename this folder
Ensure the SBO-Common version, the SAP Business One company database version and the DI version are ok.
- Common version- stored in the SINF table of the SBO-COMMON database
- Database version – stored in the CINF table in the company database
- DI Version – OBServer.dll -> Properties -> Special Build Description