Was this issue resolved? I am seeing the same issue when the the connect statement is issued"



PB 2019 R3 Build 2670.



// Profile PB Demo DB V2019R3

SQLCA.DBMS = "ODBC"

SQLCA.AutoCommit = False

SQLCA.DBParm = "ConnectString='DSN=PB Demo DB V2019R3;UID=dba;PWD=sql'"

connect;



The error is a follows:



System.Web.Services.Protocols.SoapException: Exception has been thrown by the target of an invocation. ---> System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.IO.FileNotFoundException: Could not load file or assembly 'Sybase.PowerBuilder.Interop.dll' or one of its dependencies. The specified module could not be found.

at c__n_webservice.constructor()

--- End of inner exception stack trace ---

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at Sybase.PowerBuilder.EventRequest.Invoke(PBSessionBase session)

at Sybase.PowerBuilder.PBEventTrigger.TriggerEvent(PBPowerObject po, PBString e)

at Sybase.PowerBuilder.PBSessionBase.TriggerEvent(PBPowerObject po, PBString e)

at Sybase.PowerBuilder.PBPowerObject.TriggerEvent(PBString e)

at c__n_webservice.create() in c:\Users\micha\OneDrive\Dev\MiddlesexSoftware\FMS\pb2cstempout\webservice\n_webservice.cs:line 0

at Sybase.PowerBuilder.PBPowerObject.OnCreate(Boolean init)

at Sybase.PowerBuilder.PBSessionBase.CreateInstance(PBPowerObject parent, Type type, Boolean init, Boolean is4ApplicationInit, Object[] parm)

at Sybase.PowerBuilder.PBSessionBase.CreateInstance(PBPowerObject parent, Type type, Object[] parm)

at Sybase.PowerBuilder.PBPowerObject.CreateInstance(Type type, Object[] parm)

at Sybase.PowerBuilder.Web.WebServices.PBWebService.CreateObject(Type t)

at Sybase.PowerBuilder.Web.WebServices.PBWebService.Prepare()

at Sybase.PowerBuilder.Web.WebServices.PBWebService.Initialize()

at cns_webservice.PBWS__n_webservice.of_start(Int16 al_start) in c:\Users\micha\OneDrive\Dev\MiddlesexSoftware\FMS\pb2cstempout\webservice\webservice.asmx.cs:line 42

--- End of inner exception stack trace ---

The .NET stuff Sybase built was flawed design so we junked it. It remains in PB 2019 R3 as an "obsolete" feature only because some people really using it and we wanted newer versions to be backwards compatible. But really, you should get off of this obsolete feature. The replacement would be to use the native C# way Appeon is doing today, which is correct design. You use the PowerScript Migrator and .NET DataStore object to migrate your NVOs to C# REST APIs. Here is more info: https://www.appeon.com/products/powerbuilder/dotnet-datastore-rest-apis

Hi Michael;

FWIW: That looks like a Web Service error - not a DBMS one. It's most likely caused because you did not replace the PBWSClientNNN.pbd with the newer "PBWSClient190.pbd" from the Appeon PB installation. Then regenerate all your Proxy objects.

Regards ... Chris