ICompany.DBServerType problems with MSSQL2019

[sap-chris]

Hi Everyone

We're trying to connect our SAP B1 trough a C# App (programming with VS2019)

We always fail because ICompany.DbServerType can't defined correctly.

When we want to specify:

oCompany.DbServerType = BoDataServerTypes.dst_MSSQL2019; ---> oCompany.DbServerType leafes empty.

On the other hand when we specifiy it as:

oCompany.DbServerType = BoDataServerTypes.dst_MSSQL2016; ---> oCompany.DbServerType containts the correct value (dst_MSSQL2016).

The problem only appears with MSSQL2019.We already spend houhrs on this but can't find a solution by ourself.

[sap-chris]

Dear Ankit

We use the newest version: Business One 10.0 FP 2105. The Upgrade was made from our SAP Partner and was successful.

Kind regards

Christian

[ANKIT_CHAUHAN]

Dear sap-chris,

Can you check the modified date of SAPBusinessOneSDK.dll under folder “C:\Windows\Microsoft.NET\assembly\GAC_MSIL\SAPBusinessOneSDK”?

Is it the same date when the upgrade took place? If it is an older date, it means that SAPBusinessOneSDK.dll was not updated successfully during the upgrade process.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[sap-chris]

Dear Ankit

The dll must be the newest version. We installed SAP from scratch on a completely new Windows Server and migrate only the database from the old server.

Kind regards

Christian

[ANKIT_CHAUHAN]

Dear sap-chris,

You can create an incident for SAP Business One Support Team under the component SBO-SDK-DI in order to get it investigated.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[sap-chris]

Dear Ankit

To solve the issue, we decided to migrate our Software to Service Layer API.
If you think we should report this Bug to SAP Business One Support Team anyway, pls tell me how I can contact them.

Kind regards

Christian

[ANKIT_CHAUHAN]

Dear sap-chris,

This is more relevant to an environment specific issue. We are able to make company connection using MS SQL 2019.

Your SAP Business One Partner can create an incident for SAP Business One Support team, if you would like it to be investigated.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[sap-chris]

Dear Ankit

Thank you very much for you help!

Allright, I'll forward this topic to our SAP Partner.

Kind regards

Christian