I am trying to setup PowerServer on my local machine and have come across an error that I can't find any information about.  When trying to connect to Oracle or SQL Server the same box comes up.  "No data provider of database type 'Oracle' is found, you need to add a data provider before using the database."  If a SQL Server is chosen the message changes the one word to 'SqlServer'

When I go to the Database Configuration both connections test successfully.  When I change the cache name to the other and the connection string in the app open I get the error.  When running the program through the IDE as a standard client both transactions connect with no issues.

Looking at the localhost IIS log I see the connection get request followed by a fail line.

dbug: PowerServer.Api.ServerApiController[0]
'PowerServer.Api.ServerApiController.CreateSessionAsync (PowerServer.Api)' get request ({
"reqData": {
"Type": 31,
"Content": {
"CreateSession": {
"ApplicationName": null,
"SecureString": "Blah Blah Blah",
"SessionId": null
}
},
"ClientIPAddress": "",
"ServerIPAddress": "",
"ServerPort": 0,
"AppName": "TestApp",
"NamespaceName": "TestApp",
"SecureSession": "",
"Version": "1.0",
"RequestId": "0D9A3FC2-D44E-4dd5-84A1-5EBEE1FDA12D",
"Transaction": null
}
}).
dbug: PowerServer.Api.ServerApiController[0]
'PowerServer.Api.ServerApiController.CreateSessionAsync (PowerServer.Api)' get result ({
"IsSuccess": true,
"ErrorCode": 0,
"ErrorMessage": null,
"Version": "1.0",
"RequestId": "0D9A3FC2-D44E-4dd5-84A1-5EBEE1FDA12D",
"AppName": "TestApp",
"Session": {
"ErrCode": 0,
"ErrMsg": null,
"SessionId": null
},
"Type": 31,
"Transaction": {
"TransactionId": null,
"SQLCode": 0,
"SQLDBCode": 0,
"SQLErrText": null,
"SQLNRows": 0,
"SQLReturnData": null
},
"Content": {
"SessionState": null,
"SessionInfo": {
"SessionId": "0528CF3F-7B18-4EEB-A00C-5E1DF996DEB5"
},
"GracePeriod": {
"Remind": false,
"RemainingDays": 0
},
"PsVersion": "1.1.0",
"Watermark": "For Development Use Only",
"LicenseMode": "Subscription",
"SecureString": "Blah Blah Blah",
"RequestTimeout": 3600
},
"Namespace": "TestApp"
}).
info: Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor[1]
Executing ObjectResult, writing value of type '♣ '.
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2]
Executed action PowerServer.Api.ServerApiController.CreateSessionAsync (PowerServer.Api) in 197.5154ms
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Executed endpoint 'PowerServer.Api.ServerApiController.CreateSessionAsync (PowerServer.Api)'
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 324.8729ms 200 application/json; charset=utf-8
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 POST http://localhost:5000/api/ServerApi/ConnectAndCreateTransaction application/json;charset=UTF-8 1216
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 POST http://localhost:5000/api/ServerApi/VerificationFiles application/json;charset=UTF-8 0
info: Microsoft.AspNetCore.Authorization.DefaultAuthorizationService[1]
Authorization was successful.
info: Microsoft.AspNetCore.Authorization.DefaultAuthorizationService[1]
Authorization was successful.
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint 'PowerServer.Api.ServerApiController.VerificationFilesAsync (PowerServer.Api)'
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint 'PowerServer.Api.ServerApiController.ConnectAndCreateTransactionAsync (PowerServer.Api)'
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[3]
Route matched with {action = "VerificationFiles", controller = "ServerApi"}. Executing controller action with signature System.Threading.Tasks.Task`1[System.String] VerificationFilesAsync() on controller PowerServer.Api.ServerApiController (PowerServer.Api).
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[3]
Route matched with {action = "ConnectAndCreateTransaction", controller = "ServerApi"}. Executing controller action with signature System.Threading.Tasks.Task`1[PowerServer.Core.IBaseResult] ConnectAndCreateTransactionAsync(PowerServer.Core.RequestConnect) on controller PowerServer.Api.ServerApiController (PowerServer.Api).
info: Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor[1]
Executing ObjectResult, writing value of type 'System.String'.
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2]
Executed action PowerServer.Api.ServerApiController.VerificationFilesAsync (PowerServer.Api) in 17.3216ms
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Executed endpoint 'PowerServer.Api.ServerApiController.VerificationFilesAsync (PowerServer.Api)'
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 48.4714ms 200 text/plain; charset=utf-8
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 POST http://localhost:5000/api/ServerApi/verificationresult application/json;charset=UTF-8 0
info: Microsoft.AspNetCore.Authorization.DefaultAuthorizationService[1]
Authorization was successful.
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint 'PowerServer.Api.ServerApiController.VerificationResultAsync (PowerServer.Api)'
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[3]
Route matched with {action = "VerificationResult", controller = "ServerApi"}. Executing controller action with signature System.Threading.Tasks.Task`1[System.String] VerificationResultAsync() on controller PowerServer.Api.ServerApiController (PowerServer.Api).
info: Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor[1]
Executing ObjectResult, writing value of type 'System.String'.
dbug: PowerServer.Api.ServerApiController[0]
'PowerServer.Api.ServerApiController.ConnectAndCreateTransactionAsync (PowerServer.Api)' get request ({
"reqData": {
"Type": 7,
"Content": {
"Connect": {
"ApplicationName": null,
"CacheName": "",
"CacheGroup": "",
"TransactionName": "sqlca",
"Transaction": {
"AutoCommit": false,
"Database": "",
"DBMS": "ODBC",
"DBParm2": null,
"dbparm": "ConnectString='DSN=Summit;UID= ****;PWD=****",
"DBPass": "",
"Lock": "",
"LogID": "",
"LogPass": "",
"ServerName": "",
"SQLCode": 0,
"SQLDBCode": 0,
"SQLErrText": null,
"SQLNRows": 0,
"SQLReturnData": null,
"UserID": ""
}
}
},
"AppName": "TestApp",
"NamespaceName": "TestApp",
"SecureSession": "Blah Blah Blah",
"Version": "1.0",
"RequestId": "98836696-9D71-40c2-B2B1-2A6ABA1B9FD6",
"Transaction": null
}
}).
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2]
Executed action PowerServer.Api.ServerApiController.VerificationResultAsync (PowerServer.Api) in 3.4522ms
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Executed endpoint 'PowerServer.Api.ServerApiController.VerificationResultAsync (PowerServer.Api)'
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 20.0042ms 200 text/plain; charset=utf-8
dbug: PowerServer[0]
Validate Session Id: '0528CF3F-7B18-4EEB-A00C-5E1DF996DEB5' Session Status: 'Created' Session Last Visit Time: '12/7/2021 2:13:25 AM'
info: Microsoft.AspNetCore.Hosting.Diagnostics[1]
Request starting HTTP/1.1 POST http://localhost:5000/api/ServerApi/verify application/json;charset=UTF-8 19814
info: Microsoft.AspNetCore.Authorization.DefaultAuthorizationService[1]
Authorization was successful.
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[0]
Executing endpoint 'PowerServer.Api.ServerApiController.VerifyAsync (PowerServer.Api)'
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[3]
Route matched with {action = "Verify", controller = "ServerApi"}. Executing controller action with signature System.Threading.Tasks.Task`1[System.String] VerifyAsync(PowerServer.Core.RequestSecurityVerification) on controller PowerServer.Api.ServerApiController (PowerServer.Api).
info: Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor[1]
Executing ObjectResult, writing value of type 'System.String'.
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2]
Executed action PowerServer.Api.ServerApiController.VerifyAsync (PowerServer.Api) in 7.309ms
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Executed endpoint 'PowerServer.Api.ServerApiController.VerifyAsync (PowerServer.Api)'
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 21.9043ms 200 text/plain; charset=utf-8
fail: PowerServer.Api.ServerApiController[0]
'PowerServer.Api.ServerApiController.ConnectAndCreateTransactionAsync (PowerServer.Api)' get result ({
"IsSuccess": false,
"ErrorCode": 0,
"ErrorMessage": "No data provider of database type `SqlServer' is found, you need to add a data provider before using the database",
"Version": "1.0",
"RequestId": "98836696-9D71-40c2-B2B1-2A6ABA1B9FD6",
"AppName": "TestApp",
"Session": {
"ErrCode": 0,
"ErrMsg": null,
"SessionId": "0528CF3F-7B18-4EEB-A00C-5E1DF996DEB5"
},
"Type": 7,
"Transaction": {
"TransactionId": null,
"SQLCode": -1,
"SQLDBCode": -1,
"SQLErrText": "No data provider of database type `SqlServer' is found, you need to add a data provider before using the database",
"SQLNRows": 0,
"SQLReturnData": null
},
"Content": {
"ServerConfig": {
"DelimitIdentifier": "no",
"Ojsyntax": null,
"CaseConversion": 0,
"Dbms": null
}
},
"Namespace": "TestApp"
}).
info: Microsoft.AspNetCore.Mvc.Infrastructure.ObjectResultExecutor[1]
Executing ObjectResult, writing value of type '♣ '.
info: Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker[2]
Executed action PowerServer.Api.ServerApiController.ConnectAndCreateTransactionAsync (PowerServer.Api) in 108.9313ms
info: Microsoft.AspNetCore.Routing.EndpointMiddleware[1]
Executed endpoint 'PowerServer.Api.ServerApiController.ConnectAndCreateTransactionAsync (PowerServer.Api)'
info: Microsoft.AspNetCore.Hosting.Diagnostics[2]
Request finished in 140.6482ms 200 application/json; charset=utf-8