Hi BKR,

1) Have you modified the appsettings.json file?

Please refer to the README.md in https://github.com/Appeon/.NET-DataStore-Example:

In the Solution Explorer, open the file appsettings.json, and modify the Data Source, Initial Catalog, User ID, and Password in the connection string based on your environment. Note that the value of the Initial Catalog must be the same as the name of the database (AdventureWorks2012 by default) you restored in the SQL Server.

2) You can also verify a Web API by Web API Tester to check if you can get the correct response from any action. For how to use the Web API Tester, please refer to:

https://docs.appeon.com/snapdevelop2019r3/Testing_with_Web_API_Tester/index.html

Regards,

Logan

Hello,

Looks like the error is not able to connect to SQL Server from Snap Develop.   The same SQL Server could be connected from Powerbuilder (in the same machine and from other machines).  

What could be the possibility for not connecting to SQL Server from snap develop ?

Happiness Always
BKR Sivaprakash

Hi BKR;

  Yes, please do steps #2 and #1 in that order

   To get the PowerClient pieces installed under IIS, you need to create and upload the "Cloud App Launcher" from the PB IDE's "PowerClient" project or via the PB IDE's "Tools" menu to IIS. Once that is done, you should be able to deploy & run R3 based PowerClient Apps.

  Since you now have IIS installed, SNAP Develop should now be installable and usable for C# Web API web service creation and publication to your IIS server.

Regards ... Chris

Thanks Logan

Here is my appsettings.json

****************************
{
"Logging": {
"LogLevel": {
"Default": "Warning"
}
},
"AllowedHosts": "*",
"ConnectionStrings": {
//"AdventureWorks": "Host=192.168.1.21;Database=AdventureWorks;Port=5433;Username=postgres;Password=pass;TCP Keepalive Time=0;Keepalive=0;Command Timeout=30;TCP Keepalive Interval=0;Timeout=15;Connection Pruning Interval=10;Connection Idle Lifetime=300;Maximum Pool Size=100;Minimum Pool Size=0;Internal Command Timeout=-1;Read Buffer Size=8192;Socket Receive Buffer Size=8192;Pooling=True;Socket Send Buffer Size=8192;Max Auto Prepare=0;Auto Prepare Min Usages=5;Use Perf Counters=False;No Reset On Close=False;Convert Infinity DateTime=False;Write Buffer Size=8192;Persist Security Info=False;Include Realm=False;Enlist=False;Integrated Security=False;Encoding=UTF8;Trust Server Certificate=False;Check Certificate Revocation=False;SSL Mode=Disable"

"AdventureWorks": "Data Source=EliteJava\SQL2012;Initial Catalog=AdventureWorks2012;Integrated Security=False;User ID=sa;Password=pass;Pooling=False;Min Pool Size=0;Max Pool Size=100;ApplicationIntent=ReadWrite"
}
}

***********************

First connection [commented] to connect Postgres, which get connected.
Second one [ non-commented] to connect SQLServer, which gives me error

The message which I get while running Test of SampleController.cs is
Failed to start the Web API Tester. Please check the output error message.

The following is the error message
**************************************************

Web API Tester->The test service has started and is listening on port 65533.
Host-> Host failed to start: System.FormatException: Could not parse the JSON file.
Host->  ---> System.Text.Json.JsonReaderException: 'S' is an invalid escapable character within a JSON string. The string should be correctly escaped. LineNumber: 9 | BytePositionInLine: 45.
Host->    at System.Text.Json.ThrowHelper.ThrowJsonReaderException(Utf8JsonReader& json, ExceptionResource resource, Byte nextByte, ReadOnlySpan`1 bytes)
Host->    at System.Text.Json.Utf8JsonReader.ConsumeStringAndValidate(ReadOnlySpan`1 data, Int32 idx)
Host->    at System.Text.Json.Utf8JsonReader.ConsumeString()
Host->    at System.Text.Json.Utf8JsonReader.ConsumeValue(Byte marker)
Host->    at System.Text.Json.Utf8JsonReader.ReadSingleSegment()
Host->    at System.Text.Json.Utf8JsonReader.Read()
Host->    at System.Text.Json.JsonDocument.Parse(ReadOnlySpan`1 utf8JsonSpan, Utf8JsonReader reader, MetadataDb& database, StackRowStack& stack)
Host->    at System.Text.Json.JsonDocument.Parse(ReadOnlyMemory`1 utf8Json, JsonReaderOptions readerOptions, Byte[] extraRentedBytes)
Host->    at System.Text.Json.JsonDocument.Parse(ReadOnlyMemory`1 json, JsonDocumentOptions options)
Host->    at System.Text.Json.JsonDocument.Parse(String json, JsonDocumentOptions options)
Host->    at Microsoft.Extensions.Configuration.Json.JsonConfigurationFileParser.ParseStream(Stream input)
Host->    at Microsoft.Extensions.Configuration.Json.JsonConfigurationProvider.Load(Stream stream)
Host->    --- End of inner exception stack trace ---
Host->    at Microsoft.Extensions.Configuration.Json.JsonConfigurationProvider.Load(Stream stream)
Host->    at Microsoft.Extensions.Configuration.FileConfigurationProvider.Load(Boolean reload)
Host-> --- End of stack trace from previous location where exception was thrown ---
Host->    at Microsoft.Extensions.Configuration.FileConfigurationProvider.HandleException(ExceptionDispatchInfo info)
Host->    at Microsoft.Extensions.Configuration.FileConfigurationProvider.Load(Boolean reload)
Host->    at Microsoft.Extensions.Configuration.FileConfigurationProvider.Load()
Host->    at Microsoft.Extensions.Configuration.ConfigurationRoot..ctor(IList`1 providers)
Host->    at Microsoft.Extensions.Configuration.ConfigurationBuilder.Build()
Host->    at Microsoft.Extensions.Hosting.HostBuilder.BuildAppConfiguration()
Host->    at Microsoft.Extensions.Hosting.HostBuilder.Build()
Host->    at SnapDevelop.WebApiTester.Host.TargetFrameworkHost_3x.Initialize(String[] args)
Host->    at SnapDevelop.WebApiTester.Host.WebApiTesterHost..ctor(String[] args)
Host->    at SnapDevelop.WebApiTester.Host.Program.Main(String[] args)
Host-> 
The process has exited.
Host->Web API Tester stop.

************************************************

Any idea ?

Hi BKR,