Okay.

I give up (and for me that is usually very hard to say)!

I did verify and it should all be ok.

but when running the salesdemo app:

---------------------------
Error
---------------------------
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---------------------------
OK   
---------------------------

e\POWERBUILDER2019\PB-RestClient-Example\NET-DataStore\.NET-DataStore\Appeon.DataStoreDemo.SqlServer\Services\Impl\ServiceBase.cs:line 18
   at Appeon.DataStoreDemo.SqlServer.Controllers.ProductController.WinOpen() in D:\_WizSource\POWERBUILDER2019\PB-RestClient-Example\NET-DataStore\.NET-DataStore\Appeon.DataStoreDemo.SqlServer\Controllers\ProductController.cs:line 37
   at lambda_method(Closure , Object , Object[] )
   at Microsoft.Extensions.Internal.ObjectMethodExecutor.Execute(Object target, Object[] parameters)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.SyncObjectResultExecutor.Execute(IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeActionMethodAsync()
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeNextActionFilterAsync()
--- End of stack trace from previous location where exception was thrown ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.InvokeInnerFilterAsync()
--- End of stack trace from previous location where exception was thrown ---
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|19_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted)
   at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker)
   at Microsoft.AspNetCore.Routing.EndpointMiddleware.<Invoke>g__AwaitRequestTask|6_0(Endpoint endpoint, Task requestTask, ILogger logger)
   at Microsoft.AspNetCore.ResponseCompression.ResponseCompressionMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context)
   at Microsoft.AspNetCore.Server.Kestrel.Core.Internal.Http.HttpProtocol.ProcessRequests[TContext](IHttpApplication`1 application)
ClientConnectionId:00000000-0000-0000-0000-000000000000
Error Number:2,State:0,Class:20

Hi Miguel, 

If you are interested in eCharts, here you can find another PBApp! 

Example Graph App -- This demo app is newly added in 2019 R3. It uses the PowerBuilder WebBrowser control to render the third-party visual charts (such as Google Charts, Apache EChart etc.) which are exposed as JavaScript classes. These JavaScript/HTML5 charts can be served as a useful supplement to the PowerBuilder Graph DataWindow control.

This one connects to a SQL Anywhere database that comes in 2019R3 New build version 2670 Installation Package!. 

Regards!

This is the correct DB 

AdventureWorks2012 * 

Hi Miguel

I'm sharing with you my setup. 

I have created an SNC profile on my localhost connected to SQL-Server 64 - 2017.

Is your server on the localhost?

Check you are choosing the right provider according to your SQL-Server version.

Please let me know if this helps! 

Regards!

Hi Miguel 

Please try to connect to your DB natively using SNC and then modify the ConnectionString to your actual DB to see if that works.

Regards!

this is what I get when running the snapdevelop solution:

this is what I get when trying to run the appeon salesdemo:

the database is installed on my same PC and remote access is enabled.

regards.

Hi Miguel,

Please check the connection string.

"Catalog=AdventureWorks2012;Integrated Security=False;User ID=sa;Password=Appeon123456"

(Please notice that the backup provided creates a AdventureWorks2012 Database and the connection string only says  AdventureWorks).

Regards!