BOI Error on VB.net and Sage 100 Premium (SQL)

Help....

I have a VB.NET application that works perfectly on Mas 90 4.5 Advanced and Sage 2014 Advanced but not on Sage 100 214 Premium (SQL).

It stops on workstations either with 32 or 64 bit, on the following line when initiating a session:

oSS = oScript.NewObject("SY_SESSION")

with the following error:

System.Runtime.InteropServices.COMException (0x80020009): Exception occurred. (Exception from HRESULT: 0x80020009 (DISP_E_EXCEPTION))

Curiously, it works perfectly fron the Sage 100 214 Premium (SQL) Server (where the workstation is installed).

What could it be?  "Allow External Access"  is checked, the path is verified,  i have tested 2014 update 3 and 4

This is a summary of my app opening a session:

Dim oScript As New ProvideX.Script
Dim oSS As ProvideX.PvxDispatch
oScript = New ProvideX.Script
oScript.Init("\\SAGE100SERVER\Sage 100 Premium ERP\MAS90\Home")
oSS = oScript.NewObject("SY_SESSION")

  • 0

    Hi Daniel,

    This sounds like an issue I ran into where the version of SQL Native Client that Sage 100 is using on the server is not installed on the workstation.
    This would explain why it works on the server but not the workstation.

    In my case, the Sage 100 server was configured for version 11.0 of the client:
    'Driver={SQL Server Native Client 11.0}';

    But the workstation only had version 10.0 (verified by checking the Drivers tab in the ODBC Data Source Administrator).
    *Downloading and installing Microsoft's SQL Native Client version 11 corrected the problem.

    Hope this helps!
    Thank you

    Bret Richion, Sage